Passing Joins to ODBC

For a multiple libref join to pass to ODBC, all of these components of the LIBNAME statements must match exactly:

• user ID (USER=)
• password (PASSWORD=)
• data source (DATASRC=)
• catalog (QUALIFIER=)
• update isolation level (UPDATE_ISOLATION_LEVEL=, if specified)
• read isolation level (READ_ISOLATION_LEVEL=, if specified)
• prompt (PROMPT=, must not be specified)

Outer joins between two or more tables can be passed to the DBMS. However, the outer joins must not be mixed with inner joins in a query.

For more information about when and how SAS/ACCESS passes joins to the DBMS, see Passing Joins to the DBMS.