Synopsis
Description
Use theSET statement in SQL routines to assign a
value to a variable, referenced by comma-separated identifiers. The
value is determined by evaluating the expression after the = sign.
Before the assignment the variable must be defined with a DECLARE statement.
The data type of the variable must be identical to the data type of evaluating
the expression.
Examples
The following functions returns the value1 after setting the counter variable
multiple times to different values:
SET statement
in combination with other statements are available in the SQL routines examples
documentation.