QUALIFIER=

QUALIFIER=

Specifies the qualifier to use when reading a data source, such as DBMS tables and views.

Default value: default schema name

Option type: LIBNAME and Data set

Syntax
Details

Syntax

QUALIFIER=<qualifier-name>

Details

QUALIFIER= is optional. If it is omitted, you use the default qualifier name, if any, for the data source. QUALIFIER= can be used for any data source, such as a DBMS object, that allows three-part identifier names: qualifier.schema.object. For example, in the following SAS/ACCESS LIBNAME statement, any reference to SAS in the DBLIB.EMP table would be sent to the DBMS as rfcdept.hrdiv.emp.

libname dblib oledb provider=sqloledb 
 properties=('User ID'=suzanne Password=mypw3 
             "data source"=t1007 
             "initial catalog"=mgr1) 
schema=hrdiv qualifier=rfcdept;

Chapter Contents
Previous
Next
Top of Page

Default value:	default schema name
Option type:	LIBNAME and Data set