BL_LOAD_REPLACE= Data Set Option

Specifies whether DB2 will append or replace rows during bulk loading.
Valid in: DATA and PROC steps
Default: NO
Supports: DB2 UNIX/PC
Syntax
Details

Syntax

BL_LOAD_REPLACE=NO | YES

Syntax Description

NO
appends new rows of data to the DB2 table.
YES
replaces the existing data in the table.

Details

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);
Copyright © SAS Institute Inc. All rights reserved.