Data Set Options for Relational Databases |
Specifies the qualifier to use when you are reading database objects,
such as DBMS tables and views.
Default value: |
LIBNAME setting
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
HP Neoview, Microsoft SQL Server, MySQL,
Netezza, ODBC, OLE DB
|
QUALIFIER=<qualifier-name>
|
If this option is omitted, the default
qualifier name, if any, is used 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.
To assign this option to a group of
relational
DBMS tables or views, see the QUALIFIER= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.