DB2 Universal Database for iSeries SQL Reference

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 another label in the SQL function, SQL procedure, or SQL trigger and it cannot be the same as the name of the SQL function, SQL procedure, or SQL trigger in which the label is used.
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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]