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 © SAS Institute Inc. All rights reserved.