QUALIFIER= LIBNAME Statement Option

Identifies database objects, such as tables, by using a qualifier.

Valid in:	LIBNAME statement
Alias:	CATALOG=
Default:	none
Supports:	DB2 under UNIX and PC, Greenplum, MySQL, ODBC, Oracle, Teradata

Syntax

Details

Example

Syntax

QUALIFIER= qualifier-name

Details

If this option is omitted, the default qualifier name, if any, is used for the data source. QUALIFIER= can be used for any data source that allows three-part identifier names: qualifier.schema.object.

MySQL Details: The MySQL driver does not support three-part identifier names, so a two-part name is used (such as qualifier.object).

Example: Specifying Use of a Three-Part Name

In the following LIBNAME statement, the QUALIFIER= option causes any reference in SAS to MyDBLib.Employee to be interpreted by a DB2 database as MyDept.Scott.Employee.

libname mydblib fedsvr server="d1234.us.company.com" 
   port=2171 user=user1 pwd=pass1
   dsn=db2dsn qualifier=mydept schema=scott;

QUALIFIER= LIBNAME Statement Option

Syntax

Details

Example: Specifying Use of a Three-Part Name

See Also