ANSI-Compliant Databases

You create an ANSI-compliant database when you use the MODE ANSI keywords in the CREATE DATABASE statement. You can use the same SQL statements with both ANSI-compliant databases and non-ANSI-compliant databases. You might want to create an ANSI-compliant database for the following reasons:

• Privileges and access to objects

  ANSI rules govern privileges and access to objects such as tables and synonyms.

• Name isolation

  The ANSI table-naming scheme allows different users to create tables in a database without having to worry about name conflicts.

• Transaction isolation
• Data recovery

  ANSI-compliant databases enforce unbuffered logging and automatic transactions for Dynamic Server.

For information about ANSI-compliant databases, see the IBM Informix Database Design and Implementation Guide and the IBM Informix Guide to SQL: Syntax.