Naming conventions

The rules for forming a name depend on the type of the object designated by the name.

The syntax diagrams use different terms for different types of names. The following list defines these terms.

column-name

A qualified or unqualified name that designates a column of a table.

A qualified column name is a qualifier followed by a period and an SQL identifier. The qualifier is a table name, a view name, a synonym, an alias, or a correlation name. The unqualified column name is an SQL identifier.

cursor-name

An SQL identifier that designates an SQL cursor.

descriptor-name

A host identifier that designates an SQL descriptor area (SQLIMSDA). See References to host variables for a description of a host identifier. A descriptor name never includes an indicator variable.

host-variable

A sequence of tokens that designates a host variable. A host variable includes at least one host identifier, as explained in References to host variables.

statement-name

An SQL identifier that designates a prepared SQL statement.

table-name

A qualified or unqualified name that designates a table (IMS segment).

A one-part or unqualified table name is an SQL identifier with two implicit qualifiers.