The LIBNAME Statement for Relational Databases QUALIFIER= LIBNAME Option 115
If the libref specifies PRESERVE_TAB_NAMES=NO, then the PROC DATASETS
output is one table name, MY_TABLE. This is the only table name that is in Oracle
normalized form (uppercase letters and a valid symbol, the underscore). My_Table is
not displayed because it is not in Oracle normalized form, and MY TABLE is not
displayed because it is not in SAS member normalized form (the embedded space is a
nonstandard SAS character).
If the libref specifies PRESERVE_TAB_NAMES=YES, then the PROC DATASETS
output includes all three table names, My_Table, MY_TABLE, and MY TABLE.
See Also
“PRESERVE_COL_NAMES= LIBNAME Option” on page 112
QUALIFIER= LIBNAME Option
Enables you to identify database objects, such as tables and views, using the specified qualifier
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: ODBC, OLE DB, Microsoft SQL Server
Default value:
none
Syntax
QUALIFIER=<qualifier-name>
Details
If this option is omitted, the default is the default DBMS qualifier name, if any.
QUALIFIER= can be used for any DBMS that allows three-part identifier names, such
as qualifier.schema.object.
Examples
In the following libname statement, the QUALIFIER= option causes any reference in
SAS to MyDbLib.Employee to be interpreted by ODBC as MyDept.Scott.Employee.
libname mydblib odbc dsn=myoracle
password=testpass schema=scott
qualifier=mydept;
In the following example, the QUALIFIER= option causes any reference in
mydblib.employee to SAS to be interpreted by OLE DB 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;
