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.
Database Name
Using Keywords as Table Names
Using the @ Symbol

Using the @ Symbol

The @ symbol is a literal character. If you specify a database server name, blank spaces are not valid between the @ symbol and the database server name. Either put a blank space between dbname and the @ symbol, or omit the blank space.

The following examples show valid database specifications, qualified by the database server name:

empinfo@personnel
empinfo @personnel

In these examples, empinfo is the name of the database and personnel is the name of the database server.