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.
Other syntax segmentsThese topics describe syntax segments, which are language elements, such as database object names or optimizer directives, that appear as a subdiagram reference in the syntax diagrams of some SQL or SPL statements.
Statement Block
Subset of SPL Statements Valid in the Statement Block

Subset of SPL Statements Valid in the Statement Block

The diagram for the Statement Block refers to this section. You can use any of the following SPL statements in the statement block:

<<Label >>
CALL
CASE
CONTINUE
EXIT
FOR
FOREACH
GOTO
IF
LET
LOOP
RAISE EXCEPTION
RETURN
SYSTEM
TRACE
WHILE

GOTO and << Label >>, however, are not valid in ON EXCEPTION statement blocks.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.