Previous Page | Next Page

SAS/ACCESS Interface for Informix

Passing Joins to Informix

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

user ID (USER=)
password (USING=)
server (SERVER=)

Due to an Informix database limitation, the maximum number of tables that you can specify to perform a join is 22. An error message appears if you specify more than 22.

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

Previous Page | Next Page | Top of Page