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)
|
| Default: |
NO |
| Requirement: |
To specify this option, you must first set BULKLOAD=YES. |
| Data source: |
DB2 under UNIX and PC Hosts |
| See: |
BULKLOAD= data set option |
Syntax
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.