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.

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.