1. Application Runtime for Batch Reference Guide
  2. Oracle Tuxedo Application Runtime for Batch Functions
  3. Reference
  4. Overview
  5. m_DBTableLoad
  6. Options for Oracle

2.4.1.5.5 Options for Oracle

-e <error file>
Optional.
SYSERR by default.
The ddname of the error file where are stored the errors during sqlldr command execution. When MT_DSNUTILB_LOADUNLOAD is set to "yes", this option is ignored.
-d <discard file>
Optional.
SYSERR by default.
The ddname of the file that contains the discarded data during sqlldr command execution. When MT_DSNUTILB_LOADUNLOAD is set to "yes", this option is ignored.
-D <discard file>
Optional.
999 by default
The maximum number of discarded data. When MT_DSNUTILB_LOADUNLOAD is set to "yes", this option is ignored.
-a
Optional.
When this option is set, the data to be loaded is appended to the end of the table; otherwise, this function returns "8" when table is not empty.
Only when MT_DSNUTILB_LOADUNLOAD is set to "yes", this option takes effect.
-r
Optional.
When this option is set, the table is cleaned before loading data into table; otherwise, the table is not cleaned before loading data into table.
Only when MT_DSNUTILB_LOADUNLOAD is set to "yes", this option takes effect.
-s <DB_SYSTEM>
Specifies the DB SYSTEM. This "DB SYSTEM" value is used to get the "DB connection credential string" from file specified by global variable MT_DB2_SYSTEM_MAPPING. And then apply it to MT_DB_LOGIN. After this API is executed successfully, MT_DB_LOGIN is restored.

Parent topic: m_DBTableLoad