SQL identifiers

An SQL identifier is the name of a database object.

The following objects are examples of SQL identifiers:
  • Parts of the database schema such as tables, columns, views, indexes, synonyms, and stored procedure names
  • Dynamic structures such as cursors and statement IDs

As syntax allows, you can use a host variable within an embedded SQL statement to hold the name of an SQL identifier.

For information about the sizes and naming conventions for SQL identifiers, see the Identifier segment in the HCL OneDB™ Guide to SQL: Syntax.