Allows one or more procedural SQL statements to be iteratively executed.
WHILEstatement can be used to iteratively execute a sequence of one or more
The iteration continues as long as
search-conditionevaluates to true.
For information on
procedural-sql-statements, see Procedural SQL Statements.
labelappears at the beginning and at the end of the
WHILEstatement, the same value must be specified in both places.
labelis optional, however, if
labelappears at the end of the
WHILEstatement, it must also appear at the beginning.
A label is required at the beginning if the
LEAVEstatement is to be used to terminate the
WHILEstatement may be terminated by executing the
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, Iteration Using WHILE.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40