QUALIFIER

Qualifies unqualified table and view names.
Note:

Syntax:

QUALIFIER=schema-name

Parameters:

schema-name
The name of the schema used to qualify unqualified table or view references in embedded SQL.

Dependencies:

Requires one of the following:
  • The DIALECT directive option is set to MAINFRAME
  • The DIALECT directive option is set to MIXED, and each targeted SQL statement includes the [MAINFRAME] statement prefix

Scope:

Used at compile time: Yes
Behavior at run time: Source file

See Scope - HCOSS SQL Compiler Directive Options for more information.

Comments:

When CHECK is specified, HCOSS qualifies unqualified table and view references before sending statements to SQL Server for checking.

When ACCESS and/or BIND is specified, HCOSS qualifies unqualified table and view references in generated stored procedures.

When DBRMLIB is specified, HCOSS leaves unqualified table and view references unqualified in the DBRM. You can qualify them by specifying a qualifier when executing BIND PACKAGE or BIND PLAN commands. With DBRMLIB you need only specify QUALIFIER if it is required to assist CHECK.

When none of DBRMLIB, ACCESS, and BIND are specified, HCOSS qualifies table and view references in generated code.