User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

Continue execution by leaving a compound statement or LOOP.

Syntax

     LEAVE statement-label

Usage

Procedures, triggers, and batches.

Permissions

None.

Side effects

None.

See also

• LOOP statement
• FOR statement
• Compound statements
• The chapter "Using Procedures, Triggers, and Batches"

Description

The LEAVE statement is a control statement that allows you to leave a labeled compound statement or a labelled loop. Execution resumes at the first statement after the compound statement or loop.

The compound statement that is the body of a procedure or triggers has an implicit label that is the same as the name of the procedure or trigger.

Examples

The following fragment shows how the LEAVE statement is used to leave a loop.

     SET i = 1;
     lbl:
     LOOP
         INSERT
         INTO Counters ( number )
         VALUES ( i ) ;
         IF i >= 10 THEN
             LEAVE lbl ;
         END IF ;
         SET i = i + 1
     END LOOP lbl

The following example fragment uses LEAVE in a nested loop.

     outer_loop:
     LOOP
         SET i = 1;
         inner_loop:
         LOOP
             ...
             SET i = i + 1;
             IF i >= 10 THEN
                 LEAVE outer_loop
             END IF
         END LOOP inner_loop
     END LOOP outer_loop