LEAVE statement

Description

Continues execution by leaving a compound statement or LOOP.

Syntax

LEAVE statement-label

Examples

Example 1

This code 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

Example 2

This code 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

Usage

LEAVE is a control statement that lets you leave a labeled compound statement or a labeled loop. Execution resumes at the first statement after the compound statement or loop.

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


Side effects

None

Standards

Permissions

None

See also

BEGIN … END statement

FOR statement

LOOP statement