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 tables.

Informix supports nonstandard outer-join syntax. Outer joins between two tables can be passed to the DBMS, with these restrictions:

• Full outer joins are not supported.
• Only a comparison operator is allowed in an ON clause.
• Outer joins cannot contain a WHERE clause.