Description

label
Specifies the label for the assignment-statement statement. The label name cannot be the same as the routine name or another label within the same scope. For more information, see Handling errors and warnings.
SQL-parameter-name
Identifies the SQL parameter that is the assignment target. The SQL parameter must be specified in parameter-declaration in the CREATE PROCEDURE or CREATE FUNCTION statement.
SQL-variable-name
Identifies the SQL variable that is the assignment target. SQL variables can be defined in a compound statement or be a transition variable.
expression or NULL
Specifies the expression or value that is the source for the assignment.
DEFAULT
Specifies that the default value for the column associated with the transition variable will be used. This can only be specified in SQL triggers for transition variables.
row-fullselect
A fullselect that returns a single result row. The result column values are assigned to the corresponding SQL variable or parameter. If the result of the fullselect is no rows, then null values are assigned. An error is returned if there is more than one row in the result.