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).
IF
SQL Statements Not Valid in an IF Statement

SQL Statements Not Valid in an IF Statement

The “Subset of SQL Statements” element in the syntax diagram for the IF Statement List refers to all SQL statements, except for the following SQL statements, which are not valid in the IF statement list.

ALLOCATE DESCRIPTOR
CLOSE DATABASE
CONNECT
CREATE DATABASE
CREATE PROCEDURE
DATABASE
DEALLOCATE DESCRIPTOR
DESCRIBE
DISCONNECT
DROP DATABASE
EXECUTE
FLUSH
GET DESCRIPTOR
GET DIAGNOSTICS
INFO
LOAD
OUTPUT
PUT
RENAME DATABASE
SET AUTOFREE
SET CONNECTION
SET DESCRIPTOR
UNLOAD
WHENEVER

You can use a SELECT statement only if you use the INTO TEMP clause to store the result set of the SELECT statement in a temporary table.

Related Statements

WHILE