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.
Delimited Identifiers
Support for Nonalphanumeric Characters

Support for Nonalphanumeric Characters

By default, ASCII letters, digits, and the underscore (ASCII 95) character are supported in SQL identifiers and in storage object identifiers for all locales. To include additional characters from the codeset implied by the DB_LOCALE setting in the names of database objects, you must use delimited identifiers.

You cannot , however, use delimited identifiers, however, to specify characters that are not letters, digits, or the underscore ( _ ) character when you declare or reference the names of storage objects, such as dbspaces, partitions, blobspaces, or sbspaces.