SQL Concepts and Language Elements › Supported SQL Language Elements › Host Variables › Qualified Column Names

Qualified Column Names

In embedded SQL, you can qualify a column name with the name of an SQL object. CA Ideal supports up to two levels of qualification. This means that you cannot qualify a column name with an object name that is itself qualified by an authorization ID. For example, column name EMP_NAME can be qualified by the table name EMP_TABLE, but it cannot be further qualified as in AUTHID.EMP_TABLE.EMP_NAME.

EMP_TABLE.EMP_NAME

You can achieve the same result by using correlation names or by letting CA Ideal qualify the object name using one of the methods described previously.

CA Ideal validates column references. It checks that:

• The column name is defined in the specified dataview.
• Null eligible variables select NULL eligible columns.
• Host variables are of compatible type for the columns selected or compared.