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.
For information on procedural-sql-statements, see Procedural SQL Statements.
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.
ExampleSET I = 0; L1: WHILE I <= 10 DO ... SET I = I + 1; END WHILE L1;
For more information, see the Mimer SQL Programmer's Manual, chapter 12, Iteration Using WHILE.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40