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.