SQL Concepts and Language Elements › Supported SQL Language Elements › Host Variables › Qualified Host Variable Identifiers

Qualified Host Variable Identifiers

A host variable identifier must be qualified by a group name if it is not unique in the program.

For CA Datacom/DB: You cannot use a SQL reserved word as a host identifier.

For DB2: You can use a SQL reserved word as a host variable name if it is qualified by a group name.

You can omit the leading colon from a qualified host identifier. If you omit the colon and the group‑name qualifier is the same as a table, view, or correlation name in the current SQL statement, the reference is assumed to be to a column, not to a host variable.