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.
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")
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 23, 2017