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 under UNIX and PC

Syntax

Syntax Description

Details

Example

Syntax

BULKOPTS=(option1=value <option2=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');