Previous Page | Next Page

Data Set Options for Relational Databases

QUALIFIER= Data Set Option



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

Syntax
Details
See Also

Syntax

QUALIFIER=<qualifier-name>


Details

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.


See Also

To assign this option to a group of relational DBMS tables or views, see the QUALIFIER= LIBNAME Option.

Previous Page | Next Page | Top of Page