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 Statements with SQL Identifiers

Preparing Statements with SQL Identifiers

In general, you must specify SQL identifiers explicitly in the statement text when you prepare the statement. In a few special cases, however, you can use the question-mark ( ? ) placeholder for an SQL identifier:

For the database name in the DATABASE statement.
For the dbspace name in the IN dbspace clause of the CREATE DATABASE statement.
For the cursor name in statements that use cursor names.