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

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;