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

Statement Block

Use a statement block to specify SPL and SQL operations to take place when an SPL statement that includes this segment is executed.

Syntax

Statement Block

Notes:

¹ See DEFINE
² See ON EXCEPTION and Identifier
³ See EXECUTE FUNCTION statement
⁴ See EXECUTE PROCEDURE statement
⁵ See Subset of SPL Statements Valid in the Statement Block
⁶ See SQL Statements Valid in SPL Statement Blocks

Usage

SPL and SQL statements can appear in a statement block, a set of zero or more statements that can define the scope of a variable or of the ON EXCEPTION statement. If a statement block is empty, no operation takes place when control of execution within the SPL routine passes to the empty SPL statement block.