Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


WHILE


Allows one or more procedural SQL statements to be iteratively executed.

Usage

Procedural.

Description

The WHILE statement can be used to iteratively execute a sequence of one or more procedural SQL statements.

The iteration continues as long as search-condition evaluates to true.

Restrictions

If label appears at the beginning and at the end of the WHILE-statement, the same value must be specified in both places.

Specifying label is optional, however, if label appears at the end of the WHILE-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 WHILE-statement.

Notes

The WHILE-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

SQL/PSM

YES

Fully compliant.



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