Passing Joins to Greenplum

For a multiple libref join to pass to Greenplum, 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.
Copyright © SAS Institute Inc. All rights reserved.