SQL Mode 
The MaxDB database system supports various SQL language variants (SQL modes)
SQL Modes
Name |
Description |
INTERNAL |
Internal MaxDB definition |
ANSI |
ANSI standard in accordance with ANSI X3.135-1992, Entry SQL |
DB2 |
Definition DB2 Version 4 |
ORACLE |
Definition ORACLE 7 |
When you open a database session, you can enter the required SQL mode. The default is INTERNAL.
The database system supports SQL modes other than INTERNAL only to a limited extent for Data Definition Language (DDL) statements.
If nothing else is entered, the documentation for the database system describes the functionality available in the INTERNAL SQL mode.
See also:
SQL Reference Manual:
Entering the SQL mode with the CONNECT Statement
Loader, 
SQLMODE
Command