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