Using ANSI-Compliant Databases

You create an ANSI-compliant database when you use the MODE ANSI keywords in the CREATE DATABASE statement. However, creating an ANSI-compliant database does not ensure that this database remains ANSI-compliant. If you take a non-ANSI action (such as CREATE INDEX) on an ANSI database, you will receive a warning, but the application program does not forbid the action.

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.

You can use the same SQL statements with both ANSI-compliant databases and non-ANSI-compliant databases.