Micro Focus Enterprise Developer 2.3 for Visual Studio 2012 > Programming > Mainframe Programming > HCO for SQL Server (HCOSS) > Reference > SQL Compiler Directive Options - HCOSS > QUALIFIER

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 - 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.