BULKOPTS= Data Set Option

Container option for BL_LOAD_REPLACE=, BL_LOG=, and BL_OPTIONS= data set options.

Valid in:	DATA and PROC steps
Category:	Bulk Loading
Requirement:	Must follow BULKLOAD=YES
Supports:	DB2 UNIX/PC

Syntax

Details

Example

Syntax

BULKOPTS=(option1=value optionn=value)

Syntax Description

BL_LOAD_REPLACE=NO|YES: specifies whether the CLI LOAD interface replaces the existing data in the data set. For more information, see BL_LOAD_REPLACE= Data Set Option .

BL_LOG=pathname: specifies a file to which information about the loading process is written. For more information, see BL_LOG= Data Set Option .

BL_OPTION=option: specifies a valid DB2 option. For more information, see BL_OPTIONS= Data Set Option .

Details

The BULKOPTS= option is a container option that is required to specify BL_LOAD_REPLACE=, BL_LOG=, and BL_OPTION= data set options. To specify the BULKOPTS= option, you must first specify BULKLOAD=YES. For more information, see BULKLOAD= Data Set Option .

Example: Specifying BULKOPTS=

The following example uses BULKLOAD=YES and BULKOPTS= options:

BULKLOAD=YES;
    BULKOPTS=(BL_LOG='c:\temp\bulkload.log"  BL_LOAD_REPLACE=yes
                                  BL_OPTIONS='ERRORS=999, LOAD=2000');