Checking for ANSI Compliance

To check your SQL statements for compliance with ANSI standards, include the -ansi option or set the DBANSIWARN environment variable. Use the -ansi option with other dbaccess options such as -dc (to create a database), -tc or -ta (to create or alter a table), or -qc filename (to choose a command file). The following command checks for ANSI compliance while DB–Access creates the database research:

dbaccess -ansi -dc research

You do not need to specify the -ansi option on the command line if the DBANSIWARN environment variable is set.

DB–Access displays the SQLSTATE value with the warning under the following circumstances:

• You include the -ansi option or set the DBANSIWARN environment variable.
• You access or create an ANSI database.
• You run DB–Access in line mode or specify a .sql input file.
• Execution of a SQL statement generates a warning rather than an error.

For more information on ANSI-compliant databases, see the IBM Informix: Guide to SQL Reference and the IBM Informix: Guide to SQL Tutorial. For more information on SQLSTATE values, see the GET DIAGNOSTICS statement in the IBM Informix: Guide to SQL Syntax. The IBM Informix: Guide to SQL Syntax also provides information about ANSI compliance in Informix SQL syntax.