Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


ITERATE


Continues execution at the beginning of a labeled procedural-sql-statement.

Usage

Procedural.

Description

The ITERATE statement can be used to skip the remaining statements within a labeled procedural-sql-statement. The execution will continue at the beginning of the labeled procedural-sql-statement. The statement must be a FOR, LOOP, REPEAT or WHILE statement.

For a list of procedural-sql-statements, see Procedural SQL Statements.

The label is the beginning label of a procedural-sql-statements within the scope containing the ITERATE statement.

Restrictions

A procedural-sql-statement must have a beginning label if ITERATE is to be used.

Notes

If the ITERATE statement is contained in any compound statements which are enclosed in the procedural-sql-statement defined by the label the following actions will take place:

Example

 L1:
 LOOP
   IF ... LEAVE L1;
   ...
 END LOOP L1;
 

For more information, see Mimer SQL Programmer's Manual, chapter 12, Iteration.

Standard Compliance

Standard
Compliance
Comments
SQL-99
YES
Fully compliant.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX