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)
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.