Allows one or more procedural SQL statements to be iteratively executed.
The WHILE statement can be used to iteratively execute a sequence of one or more procedural SQL statements.
The iteration continues as long as search-condition evaluates to true.
If label appears at the beginning and at the end of the WHILE-statement, the same value must be specified in both places.
Specifying label is optional, however, if label appears at the end of the WHILE-statement, it must also appear at the beginning.
A label is required at the beginning if the LEAVE-statement is to be used to terminate the WHILE-statement.
The WHILE-statement may be terminated by executing the LEAVE-statement using label. It will also terminate if an exception condition is raised, in accordance with the normal exception handling process.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40