Allows one or more procedural SQL statements to be iteratively executed.
The REPEAT-statement can be used to iteratively execute a sequence of one or more procedural SQL statement.
The iteration continues until search-condition evaluates to true.
If label appears at the beginning and at the end of the REPEAT-statement, the same value must be specified in both places.
Specifying label is optional, however, if label appears at the end of the REPEAT-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 REPEAT-statement.
The REPEAT-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.
SQL/PSM YES Fully compliant.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40