Background documentationSQL Mode Locate this document in the navigation structure

 

The SAP MaxDB database system supports different SQL language variants (SQL modes).

SQL Modes

Name

Description

INTERNAL

SAP MaxDB SQL definition

ORACLE

ORACLE 7 SQL definition

For Data Definition Language (DDL) statements, the database system supports SQL modes other than INTERNAL only to a limited extent.

When you open a database session, you can specify the SQL mode. The default value is INTERNAL.

Note Note

If nothing else is specified, the documentation describes the SQL statements available in the INTERNAL SQL mode: SQL Syntax.

End of the note.

More Information

SQL Reference Manual,

Loader, SQLMODE Command