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.