Determining if an Existing Database Is ANSI Compliant

The following list describes two methods to determine whether a database is ANSI compliant:

• From the sysmaster database you can execute the following statement:

  SELECT name,is_ansi FROM sysmaster:sysdatabases

  The query returns the value 1 for ANSI-compliant databases and 0 for non-ANSI-compliant databases for each database on your database server.

• If you are using an SQL API such as IBM Informix ESQL/C, you can test the SQL Communications Area (SQLCA). Specifically, the third element in the SQLCAWARN structure contains a W immediately after you open an ANSI-compliant database with the DATABASE or CONNECT statement. For information on SQLCA, see the IBM Informix: Guide to SQL Tutorial or your SQL API manual.