You can use the Loader’s SQLMODE command when starting a database session to specify the SQL mode of the database instance.


<sql_mode_command> ::= SQLMODE <sql_mode>

<sql_mode> ::= INTERNAL | ANSI | DB2 | ORACLE


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


SQL dialect in accordance with the ANSI standard (ANSI X3.135-1992, Entry SQL)


SQL dialect in accordance with the definition for DB2 Version 4


SQL dialect in accordance with the ORACLE7 definition


The commands for exporting and importing data executed by the Loader and the SQL statements are interpreted in accordance with the SQL mode that has been set if the data stream does not have the PAGES format.

The defined SQL mode remains active until it is changed again using the SET SQLMODE command.

?     If you do not specify an SQL mode, the SQL mode INTERNAL is used.

?     You can change the SQL mode within a command file or a script using the SQLMODE command.

See also:

Creating a Database Session: Commands