 |
|
| SAS/ACCESS Interface to DB2 Under z/OS |
Passing Joins to DB2 Under z/OS
With these exceptions, multiple libref joins are passed to DB2 z/OS.
-
If you specify the SERVER= option for one libref, you must also specify it for the others, and its value must be the same for all librefs.
-
If you specify the DIRECT_SQL= option for one or multiple librefs, you must not set it to NO, NONE, or NOGENSQL.
For completeness, the portable code checks these options, regardless of the engine:
-
DBCONINIT=
-
DBCONTERM=
-
DBLIBINIT=
-
DBLIBTERM=
-
DIRECT_EXE=
-
DIRECT_SQL=
-
PRESERVE_COL_NAMES=
-
PRESERVE_TAB_NAMES=
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.