ANSI-Compliant Databases

When you use the LOG MODE ANSI option in the CREATE DATABASE statement, the database that you create is an ANSI-compliant database. The following example creates an ANSI-compliant database:

CREATE DATABASE employees WITH LOG MODE ANSI 

ANSI-compliant databases are different from databases that are not ANSI compliant in several ways, including the following features:

• All statements are automatically contained in transactions.
• All databases use unbuffered logging.
• Owner naming is enforced.

  You must qualify with the owner name any table, view, synonym, index, or constraint, unless you are the owner. Unless you enclose the name between quotation marks, alphabetic characters in owner names default to uppercase.

• For databases, the default isolation level is REPEATABLE READ.
• Default privileges on objects differ from those in databases that are not ANSI compliant. Users do not receive PUBLIC privilege to tables and synonyms by default.

Other slight differences exist between databases that are ANSI compliant and those that are not. These differences are noted with the related SQL statement in this manual. For a detailed discussion of the differences between ANSI compliant databases and databases that are not ANSI-compliant, see the IBM Informix Database Design and Implementation Guide.

Creating an ANSI-compliant database does not mean that you automatically receive warnings for Informix extensions to the ANSI/ISO standard for SQL syntax when you run the database. You must also use the -ansi flag or the DBANSIWARN environment variable to receive such warnings.

For additional information about -ansi and DBANSIWARN, see the IBM Informix Guide to SQL: Reference.

Related Information