NexusDB

Exit from an iterated statement.

Syntax

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

       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