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 ()
password ()
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.