IBM Informix SQL ANSI Mode

Understanding the impact of the SQL ANSI mode of IBM® Informix®.

IBM Informix allows you to create databases in ANSI mode, which is supposed to be closer to ANSI standard behavior. Other databases like ORACLE and DB2® are 'ANSI' by default.

If you are not using the ANSI mode with IBM Informix, we suggest you keep the database as is, because turning an IBM Informix database into ANSI mode can result in unexpected behavior of the programs.

Here are some ANSI mode issues extracted from the IBM Informix books:

It will take more time to adapt the programs to the IBM Informix ANSI mode than using the database interface to simulate the native mode of IBM Informix.