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:

• Every open cursor declared in the compound statements is closed.
• All variables, cursors and handlers declared in the compound statements are destroyed.
• All condition names declared in the compound statements cease to be defined.

Example

 L1:
 LOOP
   ...
 
      ITERATE L1;
   ...
 END LOOP L1;
 

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

Standard Compliance

Standard	Compliance	Comments
SQL-2011	Features outside core	Feature P002, "Computational completeness".

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se