Background documentationSQLMODE Command Locate this document in the navigation structure


You can use the Loader command SQLMODE to specify the SQL mode of the database when you start a database session.


Syntax Syntax

  1. <sql_mode_command> ::=
      SQLMODE <sql_mode>
    <sql_mode> ::=
    | ORACLE
End of the code.

The commands for exporting and importing data and the SQL statements are interpreted according to the defined SQL mode (SQL dialect) if the data stream does not have PAGES format.

SQL mode


Internal SQL mode (system default value) in the database system


SQL mode according to the ORACLE7 definition

If you do not specify an SQL mode, SQL mode INTERNAL is used. The defined SQL mode remains active until it is changed with the SET SQLMODE command. You can change the SQL mode in a command file or a script using the SQLMODE command.