| Data Set Options for Relational Databases |
Lets you
further specify exactly where a table resides.
| Alias: |
LOC=
|
| Default value: |
LIBNAME setting
|
| Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
| DBMS support: |
DB2 under z/OS
|
If you specify LOCATION=, you must also
specify the AUTHID= data set option.
The location name maps to the location in the SYSIBM.LOCATIONS
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-name.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.
To assign this option to a group of relational
DBMS tables or views, see the
LOCATION= LIBNAME Option.
AUTHID= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
