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.