Micro Focus Studio Enterprise Edition Test Server > Programming > Mainframe Programming > HCO for SQL Server (HCOSS) > Reference > SQL Compiler Directive Options - HCOSS > QUALIFIER

QUALIFIER

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 ACCESS and/or BIND HCOSS directives are set
The DBRMLIB directive option is set, and the DIALECT directive option is set to MAINFRAME
To be valid on the statement level, all three of the following are required:
- The DBRMLIB directive option is set
- The DIALECT directive option is set to MIXED
- Each targeted 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 ACCESS and/or BIND is specified but DIALECT is either not specified or it is specified with a NOCHECK override, HCOSS qualifies table and view references in generated stored procedures using the value of the QUALIFIER directive.

When ACCESS and/or BIND is specified and DIALECT is specified with no override for CHECK, HCOSS qualifies table and view references in generated stored procedures using the value of the QUALIFIER directive before being sent to the SQL Server for the compile-time check.

When DBRMLIB is specified and DIALECT is either not also specified or it is specified with a NOCHECK override, HCOSS does not qualify table or view references.

When DBRMLIB is specified and DIALECT is also specified with no override for CHECK, HCOSS qualifies table and view references in generated stored procedures using the value of the QUALIFIER directive before being sent to the SQL Server for the compile-time check. In the generated DBRMLIB, unqualified table and view references are left unqualified. You can qualify them by specifying a qualifier when executing BIND PACKAGE or BIND PLAN commands.