BULKOPTS= Table Option
Provides a container for bulk load options.
| Category: |
Bulk Loading |
| Alias: |
In Oracle, this option has the name BL_BULKOPTS= |
| Requirement: |
Must follow BULKLOAD=YES |
| Data source: |
DB2 under UNIX and PC, Oracle, Teradata |
Syntax
BULKOPTS= (
option[ ...option])
Arguments
option[ ...option]
specifies one or more
bulk load table options separated by spaces.
Details
To specify BULKOPTS=
option, you must first specify BULKLOAD=YES.
For more information,
see BULKLOAD= Table Option.The BULKOPTS= option
is a container option that is required in order to specify other bulk
load table options.
Examples
Example 1
The following example
uses the BULKLOAD=YES and BULKOPTS= options to submit bulk loading
options to DB2 under UNIX and PC:
BULKLOAD=YES BULKOPTS=(BL_LOG='c:\temp\bulkload.log' BL_LOAD_REPLACE=yes
BL_OPTIONS='ERRORS=999, LOAD=2000'); Example 2
The following example
uses the BULKLOAD=YES and BULKOPTS= options to submit bulk loading
options to Teradata. The Teradata Parallel Transporter (TPT) is used
to load data into Teradata tables when BULKLOAD=YES. The TPT job uses
the Stream operator by default. In the example below, the TD_TPT_OPER=
table option specifies to use the Load operator instead, among other
things.
BULKLOAD=YES BULKOPTS=(TD_TPT_OPER=LOAD TD_ERROR_LIMIT=1
TD_TRACE_OUTPUT=tpttrace TD_TRACE_LEVEL=TD_OPER_ALL
TD_MAX_SESSIONS=8 TD_TRACE_LEVEL_INF=TD_OPER_ALL)
Example 3
The following example
uses the BULKLOAD=YES and BL_BULKOPTS= options to submit bulk loading
options to Oracle:
BULKLOAD=YES BULKOPTS=(BL_DEFAULT_DIR='C:\mylogs' BL_LOGFILE='novemberdatalog'
BL_ERRORS=999)