Determine 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 about SQLCA, see the IBM Informix Guide to SQL: Tutorial or your SQL API manual.