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.
IdentifierAn identifier specifies the unqualified name of a database object, such as an access method, aggregate, alias, blobspace, cast, column, constraint, correlation, data type, index, operator class, partition, procedure, table, trigger, sequence, synonym, or view. Use the Identifier segment whenever you see a reference to an identifier in a syntax diagram.
Using keywords as table namesThe database server issues an error in contexts where the unqualified identifier of a table object is also a valid keyword of SQL. You can disambiguate the table name by qualifying it with the authorization identifier of the owner of the table.
Declaring keywords as names for variables in UDRsIf you use some keywords as identifiers for variables in a user-defined routine (UDR), you can create ambiguous syntax:

Declaring keywords as names for variables in UDRs

If you use some keywords as identifiers for variables in a user-defined routine (UDR), you can create ambiguous syntax:

The following constant expressions and other SQL keywords might produce unexpected results as variable names.

CURRENT
CURRENT_ROLE
CURRENT_USER
DATETIME
DEFAULT_ROLE
GLOBAL
INTERVAL
NULL
OFF
OUT
PROCEDURE
SELECT
SYSDATE
TODAY
UNITS
USER

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.