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.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
PREPARE statementUse the PREPARE statement to parse, validate, and generate an execution plan for one or more SQL statements at runtime.
Preparing Multiple SQL Statements
Restricted Statements in Multistatement Prepared Objects

Restricted Statements in Multistatement Prepared Objects

In addition to the statements listed as exceptions in Restricted Statements in Single-Statement Prepares, you cannot use the following statements in the text of a multiple-statement prepared object:

CLOSE DATABASE
CREATE DATABASE
DATABASE
DROP DATABASE
RENAME DATABASE
SELECT (with one exception)

The following types of statements are also not valid in a multistatement prepare:

Statements that can cause the current database to close during the execution of the multistatement sequence
Statements that include references to TEXT or BYTE host variables

In general, you cannot use the SELECT statement in a multistatement prepare. The only form of the SELECT statement allowed in a multistatement prepare is a SELECT statement with an INTO temporary table clause.