Data Set Options for Relational Databases BL_LOAD_REPLACE= Data Set Option 157
BL_LOAD_METHOD= Data Set Option
Specifies the method by which data are loaded into an Oracle table
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
Oracle
Default value:
INSERT when loading an empty table; APPEND when loading a table that
contains data
Syntax
BL_LOAD_METHOD= INSERT | APPEND | REPLACE | TRUNCATE
Syntax Description
INSERT
requires the DBMS table to be empty before loading.
APPEND
appends rows to an existing DBMS table.
REPLACE
deletes all rows in the existing DBMS table and then loads new rows from the data
file.
TRUNCATE
uses the SQL truncate command to achieve the best possible performance. The
DBMS table’s referential integrity constraints must first be disabled.
Details
The REPLACE and TRUNCATE values apply only when you are loading data into a
table that already contains data. In this case, you can use REPLACE and TRUNCATE
to override the default value of APPEND. Refer to the Oracle utilities documentation
for information about using the TRUNCATE and REPLACE load methods.
To specify this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165.
BL_LOAD_REPLACE= Data Set Option
Specifies whether DB2 will append or replace rows during bulk loading
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 UNIX/PC
Default value: NO
