BL_LOAD_REPLACE= Table Option

Specifies whether DB2 appends or replaces rows during bulk loading.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC

Syntax

BL_LOAD_REPLACE= NO | YES

Arguments

NO

specifies that the CLI LOAD interface appends new rows of data to the DB2 table. This is the default value.

YES

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

See Also

Table Options: