The database system can execute correct database applications and applications that are written in accordance with one of the following definitions:

• INTERNAL (internal database definition)
• ANSI Standard (ANSI X3.135-1992, Entry SQL)
• Definition DB2 Version 4
• Definition ORACLE7

The database system is able to check whether new applications comply with one of the above definitions. This means, in particular, that any extension above and beyond the selected definition is considered incorrect. Support for DDL statements in other SQL modes, however, is limited.

When connecting to the database system, one of the above-mentioned definitions or the INTERNAL SQL mode can be selected.

This document describes the functionality of the database system provided by the INTERNAL SQL mode.

Only those SQL statements are described for which the same SQL mode is used to generate the object and execute the statement for the object. If database objects are created in one SQL mode and addressed in another, the object may have properties that are not known in the current SQL mode and, therefore, cannot be described.