BL_LOAD_REPLACE= Data Set Option

Specifies whether DB2 appends or replaces rows during bulk loading.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Default: NO
Restriction: If BL_LOAD_REPLACE=YES and there is no data in the table that is replacing the DBMS table, then the DBMS table is unchanged.
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: DB2 under UNIX and PC Hosts
See: BULKLOAD= data set option

Table of Contents

Syntax

BL_LOAD_REPLACE=YES | NO

Syntax Description

NO

the CLI LOAD interface appends new rows of data to the DB2 table.

YES

the CLI LOAD interface replaces the existing data in the table.

Last updated: February 3, 2026