Description
- label
- Specifies the label for the WHILE statement. If the ending
label is specified, it must be the same as the beginning label. 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.
- search-condition
- Specifies a condition that is evaluated before each execution of the
WHILE loop. If the condition is true, the SQL-procedure-statements in the WHILE loop are executed.
- SQL-procedure-statement
- Specifies an SQL statement or statements to execute within the WHILE
loop.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.