|
|
|
|
|
|
REPEAT
Allows one or more procedural SQL statements to be iteratively executed.
Usage
Description
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.
Restrictions
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.
Notes
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.
Standard Compliance
Standard
Compliance
Comments
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|
