NexusDB V3 Manual

WHILE statement

Repeat the execution while the condition is true.

Syntax

<while statement> ::=

Usage

The WHILE statement is used to specify a repeated iteration of the statement block while the search condition is true.

See also: REPEAT 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

ITERATE;

END IF;

SET v2 = v2 - 1;

END WHILE;

RETURN v2 + p1;

      END;

      SELECT dummyFunc( 15 ) FROM #dummy;

Conformance