Description
- label
- Specifies the label for the RETURN 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.
- expression
- Specifies a value that is returned from the routine:
- If the routine is a function, expression must
be specified and the value and the value of expression must conform
to the SQL assignment rules as described in Assignments and comparisons. If assigning
to a string variable, storage assignment rules apply.
- If the routine is a procedure, the data type of expression must be INTEGER. If the expression evaluates
to the null value, a value of 0 is returned.
- NULL
- The null value is returned from the SQL function. NULL is not allowed
in SQL procedures.
- query-expression
- Specifies a query-expression value that is returned
from the routine. The query-expression is a common-table-expression or fullselect. A query-expression is only allowed in a table function.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.