You can use this Loader command when creating a database session to specify the SQL Mode of the database instance.
<sql_mode_command> ::= SQLMODE <sql_mode>
<sql_mode> ::= INTERNAL | ANSI | DB2 | ORACLE