Navigation:  NexusDB Guide > SQL Reference > SQL Statements > Control Statements >

LEAVE statement

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

LEAVE statement

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Statements > Control Statements

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

 

© Nexus Database Systems Pty Ltd.

nexus_logo