Passing Joins to Teradata

For a multiple libref join to pass to Teradata, all of these components of the LIBNAME statements must match exactly:
  • user ID (USER=)
  • password (PASSWORD=)
  • account ID (ACCOUNT=)
  • server (TDPID= or SERVER=)
You must specify the SCHEMA= LIBNAME option to fully qualify each table name in a join for each LIBNAME that you reference.
For more information about when and how SAS/ACCESS passes joins to the DBMS, see Passing Joins to the DBMS.