SQLMODE Command 

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

Syntax

<sql_mode_command> ::= SQLMODE <sql_mode>

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

INTERNAL	Internal SQL mode (system default value) in the database system
ANSI	SQL dialect in accordance with the ANSI standard (ANSI X3.135-1992, Entry SQL)
DB2	SQL dialect in accordance with the definition for DB2 Version 4
ORACLE	SQL dialect in accordance with the ORACLE7 definition

Explanation

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