Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SPL statementsThese topics describe Stored Procedure Language (SPL) statements, which you use to write SPL routines. You can store these routines in the database as user-defined routines (UDRs).
WHILEUse the WHILE statement to establish a loop with variable end conditions.

WHILE

Use the WHILE statement to establish a loop with variable end conditions.

Syntax

Notes:

¹ See Condition
² See Statement Block
³ Valid only if <<label>> precedes the first WHILE keyword


Element	Description	Restrictions	Syntax
label	Name of the loop label for this loop	Must be unique among labels in this SPL routine	Identifier

Usage

The condition is evaluated before the statement block first runs and before each subsequent iteration. Iterations® continue as long as the condition remains true. The loop terminates when the condition evaluates to not true.

If any expression within the condition evaluates to NULL, the condition becomes not true unless you are explicitly testing for NULL with the IS NULL operator.

If an expression within the condition has an UNKNOWN value because it references uninitialized SPL variables, an immediate error results. In this case, the loop terminates, raising an exception.