Previous Page | Next Page

Data Set Options for Relational Databases

BL_LOAD_REPLACE= Data Set Option



Specifies whether DB2 appends or replaces rows during bulk loading.
Default value: NO
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: DB2 under UNIX and PC Hosts

Syntax
Syntax Description
Details
See Also

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.


Details

To specify this option, you must first set BULKLOAD=YES.


See Also

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page