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.