The LIBNAME Statement for Relational Databases

QUALIFIER= LIBNAME Option

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

Default value:	none
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB

Syntax
Details
Examples
See Also

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).

Examples

In the following 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 the following 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;