SQL Mode 

There are several different SQL language variants. The database system can execute database applications that are written in accordance with one of the following SQL definitions:

·        INTERNAL: Internal database system definition

·        ANSI: ANSI standard in accordance with ANSI X3.135-1992, Entry SQL

·        DB2: DB2 Version 4 definition

·        ORACLE: ORACLE7 definition

You can specify your required SQL mode when you open a database session. The default SQL mode is INTERNAL.

There is restricted support for the Data Definition Language (DDL) statements of other SQL modes.

For information on the special features of SQL statements in the SQL mode ORACLE, see the documentation SQL Mode Oracle.