Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


LEAVE


Leaves a labeled procedural SQL statement.

Usage

Procedural.

Description

The LEAVE-statement can be used to terminate the execution of a procedural-sql-statement.

The label is the beginning label of a procedural SQL statement within the scope containing the LEAVE-statement.

Restrictions

A procedural-sql-statement must have a beginning label if LEAVE is to be used to terminate its execution.

Notes

If the LEAVE-statement is contained in a compound statement the following actions occur before execution of the compound statement is terminated, after the LEAVE-statement is executed:

If the LEAVE-statement is executed within a compound statement forming the body of a procedure, execution of the procedure will be terminated.

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