When multiple WHERE clause predicates are used in an SQL join operation, the MULTI_DATASRC_OPT= option is ignored.

For example:

  libname dbms engine multi_datasrc_opt=in_clause;
  proc sql;
  select m.i from dbms.m, work.t
    where m.i=t.i 
      and m.c=1; /* this additional predicate disables the use of the 
                    multi_datasrc_opt= option */
  quit;

The result set that is produced by the SQL query is correct, but performance might suffer.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: