BL_LOAD_REPLACE= Data Set Option

Specifies whether DB2 appends or replaces rows during bulk loading.

Syntax

BL_LOAD_REPLACE= NO | YES

appends new rows of data to the DB2 table.

replaces the existing data in the table.

This option must be specified using the BULKOPTS= container option. The BULKLOAD= data set option must be set to YES.

bulkload=yes; bulkopts=(bl_load_replace=yes);