Data Set Options for Relational Databases |
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
|
-
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.
To specify this option, you must first set
BULKLOAD=YES.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.