Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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. For a list of procedural SQL statements, see Procedural SQL Statements.

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

All intervening compound statements between the statement identified by the label and the leave statement will be left. The following actions occur before execution of the compound statements 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.

Example

 CREATE PROCEDURE procedure_name(INOUT Y INTEGER)
 CONTAINS SQL
 S0:
 BEGIN
   ...
   S1:
   BEGIN
     IF Y < 0 THEN
       SET Y = 0;
       LEAVE S0;
     END IF;
     ...
   END S1;
   ...
 END S0;

Standard Compliance

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


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX