SAS/ACCESS Interface for 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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.