QUALIFIER= LIBNAME Statement Option
Identifies database objects, such as tables, by
using a qualifier.
| Valid in: |
LIBNAME statement |
| Alias: |
CATALOG= |
| Default: |
none |
| Supports: |
DB2 UNIX/PC, Greenplum, MySQL, ODBC, Oracle, Teradata |
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 that allows three-part identifier names:
qualifier.schema.object.
MySQL
Details: The MySQL driver does not support three-part
identifier names, so a two-part name is used (such as
qualifier.object).
Example: Specifying Use of a Three-Part Name
In the following LIBNAME
statement, the QUALIFIER= option causes any reference in SAS to MYDBLIB.EMPLOYEE
to be interpreted by a DB2 database as MYDEPT.SCOTT.EMPLOYEE.
libname mydblib fedsvr server="d1234.us.company.com"
port=2171 user=user1 pwd=pass1
dsn=db2dsn qualifier=mydept schema=scott;
See Also
To apply this
option to an individual table, use the QUALIFIER= data set option.