Passing Joins to SAP IQ

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

• user ID (USER=)
• password (PASSWORD=)
• host (HOST=)
• server (SERVER=)
• database (DATABASE=)
• port (PORT=)
• data source (DSN=, if specified)
• SQL functions (SQL_FUNCTIONS=)

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