Outer joins

Use standard ISO outer join syntax instead of the old IBM® Informix® OUTER() syntax.

Old IBM Informix SQL outer joins specified with the OUTER keyword in the FROM part are not standard:
SELECT * FROM master, OUTER ( detail )
  WHERE master.mid = detail.mid
    AND master.cdate IS NOT NULL
Table 1. Informix OUTER JOIN syntax by database brand
Database Server Type Informix OUTER join support
IBM DB2® LUW Emulated, see details
IBM Informix Yes, native SQL feature
IBM Netezza Emulated, see details
Microsoft™ SQL Server Emulated, see details
Oracle® MySQL Emulated
Oracle Database Server Emulated, see details
PostgreSQL Emulated, see details
SAP HANA® Emulated, see details
SQLite Emulated, see details
Most recent database servers now support the standard ANSI outer join specification:
SELECT * FROM master LEFT OUTER JOIN detail ON (master.mid = detail.mid)
  WHERE master.cdate IS NOT NULL

it is recommended that you use recent database servers and use ANSI outer joins only.