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=)
• database (DATABASE=)
• 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.