QUALIFIER

Qualifies unqualified table and view names.

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 - HCOPG SQL Compiler Directive Options for more information.

Comments:

When CHECK is specified, HCOPG qualifies unqualified table and view references before sending statements to PostgreSQL for checking.

HCOPG qualifies table and view references in generated code.