NexusDB

Repeat the execution while the condition is true.

Syntax

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