The database system can execute database applications that are written in accordance with one of the following 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.
Support of other SQL modes is restricted with regard to DDL statements.
For information on the special features of SQL statements in the SQL mode ORACLE, see the documentation SQL Mode Oracle.