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