QUALIFIER bind option

The QUALIFIER option determines the implicit qualifier for unqualified names of tables, views, indexes, aliases, and sequences contained in the plan or package.

Command option	Option values	Used with
QUALIFIER	qualifier-name	BIND PACKAGE BIND PLAN BIND SERVICE REBIND PACKAGE ¹ REBIND PLAN

Note:

The QUALIFIER bind option is not valid for REBIND of packages for native SQL procedures or advanced triggers.

Option descriptions for QUALIFIER

QUALIFIER(qualifier-name): Specifies the value of the implicit qualifier. This value is not subject to translation when sent to a remote system for BIND or REBIND PACKAGE.

Start of change Interactions with the PLANMGMT option: If you plan to change this option and the PLANMGMT option in a REBIND command, see PLANMGMT bind option for the implications. End of change

Default values for QUALIFIER

Process	Default value
BIND SERVICE	Authorization ID of the service owner
BIND PLAN	Authorization ID of the plan owner
BIND PACKAGE	Authorization ID of the package owner
REBIND PLAN	Existing value
REBIND PACKAGE	Existing value

Catalog records for QUALIFIER

See the QUALIFIER column in SYSPACKAGE catalog table and SYSPLAN catalog table.