QUALIFIER= LIBNAME Option

Allows identification of such database objects as tables and views with the specified qualifier.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	none
Data source:	HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB
See:	QUALIFIER= data set option

Syntax

Details

Example

Syntax

QUALIFIER=<qualifier-name>

Details

If you omit this option, the default is the default DBMS qualifier name, if any. You can use QUALIFIER= for any DBMS that allows three-part identifier names, such as qualifier.schema.object.

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

Example

In this LIBNAME statement, the QUALIFIER= option causes ODBC to interpret any reference to mydblib.employee in SAS as mydept.scott.employee.

 libname mydblib odbc dsn=myoracle
         password=testpass schema=scott
         qualifier=mydept;

In this example, the QUALIFIER= option causes OLE DB to interpret any reference in SAS to mydblib.employee as pcdivision.raoul.employee.

libname mydblib oledb provider=SQLOLEDB
        properties=("user id"=dbajorge "data source"=SQLSERVR)
        schema=raoul qualifier=pcdivision;
proc print data=mydblib.employee;
run;