BULKOPTS= Table Option

Provides a container for bulk-loading options.

Category: Bulk Loading
Alias: In Oracle, this option has the name BL_BULKOPTS=
Requirement: BULKLOAD=YES must be set in order to use BULKOPTS=
Data source: DB2 under UNIX and PC, Impala, Oracle, Teradata

Syntax

BULKOPTS= (option[ ...option])

Arguments

option[ ...option]

specifies one or more bulk load table options separated by spaces.

Details

To specify BULKOPTS= table option, you must first specify BULKLOAD=YES. For more information, see BULKLOAD= Table Option.
The BULKOPTS= table option is a container option that is required in order to specify other bulk load table options.
Bulk load options are data source-specific. See FedSQL Statement Table Options by Data Source for a list of the options that can be specified in this container for each data source.

Examples

Example 1

The following example uses the BULKLOAD=YES and BULKOPTS= table 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 BL_BULKOPTS= options to submit bulk-loading options to Oracle:
BULKLOAD=YES BULKOPTS=(BL_DEFAULT_DIR='C:\mylogs' BL_LOGFILE='novemberdatalog' 
BL_ERRORS=999)

Example 3

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 4

The following example uses the BULKLOAD=YES and BULKOPTS= options to submit bulk-loading options to Impala. The bulk load request will use WebHDFS to load the data to HDFS. Note that the SAS_HADOOP_RESTFUL= environment variable must also be set to 1 for the request to succeed.
BULKLOAD=YES BULKOPTS=(USER=HDFS PASS="hdfs-pwd" 
CONFIG="my-config-path")
Last updated: February 23, 2017