set variable value

SQL/PL

Set a variable to a value

Syntax

asgt_stmt:
          SET var_ref = value_expr 
     |    SET ( var_ref [, var_ref]... ) = ( value_expr [, value_expr]... )
var_ref:
          [@]var_name

Description

The SET (assignment) statement assigns the value of expression to the variable named var_name. The data type of the expression result must be compatible with var_name's data type. The '@' prefix is required when var_name is a global variable.