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:
ANSI rules govern privileges and access to objects such as tables and synonyms.
The ANSI table-naming scheme allows different users to create tables in a database without having to worry about name conflicts.
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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]