Exit from an iterated statement.


Syntax

<leave statement> ::= LEAVE


Usage

The LEAVE statement can only be specified in the body of the REPEAT and WHILE statements to stop the iteration and exit the statement.

See also: ITERATE statement


Examples

1) The following example shows the LEAVE statement used in SQL code:

       DROP FUNCTION IF EXISTS dummyFunc;

       CREATE FUNCTION dummyFunc( p1 INTEGER )

       RETURNS INTEGER

       BEGIN

DECLARE v1, v2 INTEGER;

SET v1 = 10;

SET v2 = 10;

WHILE v1 > 0 DO

SET v1 = v1 - 1;

IF v1 >= 5 THEN

LEAVE;

END IF;

SET v2 = v2 - 1;

END WHILE;

RETURN v2 + p1;

       END;

       SELECT dummyFunc( 15 ) FROM #dummy;


Conformance

SQL:2003 standard

-

-

SQL/PSM Feature P002-09 "LEAVE statement"

Statement label is not supported

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Control Statements