The LIBNAME Statement for Relational Databases |
Allows further
qualification of exactly where a table resides.
Alias: |
LOC=
|
Default value: |
none
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
DB2 under z/OS
|
The location name maps to the location
in the SYSIBM.LOCATION catalog in the communication database.
In SAS/ACCESS Interface
to DB2 under z/OS, the location is
converted to the first level of a three-level table name: location.authid.table. The DB2 Distributed Data Facility (DDF)
makes the connection implicitly to the remote DB2 subsystem when DB2 receives
a three-level name in an SQL statement.
If you omit this option, SAS accesses the data from
the local DB2 database unless you have specified a value for the SERVER= option.
This option is not validated until you access a DB2 table.
If you specify LOCATION=, you must also specify the AUTHID= LIBNAME
option.
To apply this
option to an individual data set, see
the LOCATION= Data Set Option.
For information about accessing a database server on Linux, UNIX, or
Windows using a libref, see the
REMOTE_DBTYPE= LIBNAME Option.
AUTHID= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.