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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.