 |
|
| SAS/ACCESS Interface to DB2 Under UNIX and PC Hosts |
Passing Joins to DB2 Under UNIX and PC Hosts
For a multiple libref join to pass to DB2, all of these components of the LIBNAME statements must match exactly:
-
user ID (USER=)
-
password (PASSWORD=)
-
update isolation level (UPDATE_ISOLATION_LEVEL=, if specified)
-
read_isolation level (READ_ISOLATION_LEVEL=, if specified)
-
qualifier (QUALIFIER=)
-
data source (DATASRC=)
-
prompt (PROMPT=, must not be specified)
For more information about when and how SAS/ACCESS passes joins to the DBMS, see Passing Joins to the DBMS.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.