SQLMODE Command

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

Structure

Syntax Syntax

<sql_mode_command> ::=
  SQLMODE <sql_mode>

<sql_mode> ::=
  INTERNAL
| ANSI
| DB2
| 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`	Internal SQL mode (system default value) in the database system
`ANSI`	SQL mode according to the ANSI standard (ANSI X3.135-1992, Entry SQL)
`DB2`	SQL mode according to the definition for DB2 Version 4
`ORACLE`	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.

More Information

Command File

Opening a Session: Loader Commands