Data Set Options for Relational Databases

BL_LOAD_METHOD= Data Set Option

Specifies the method by which data is loaded into an Oracle table during bulk loading.

Default value:	INSERT when loading an empty table; APPEND when loading a table that contains data
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Oracle

Syntax
Syntax Description
Details
See Also

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. You must first disable the referential integrity constraints of the DBMS table.

Details

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

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. See your Oracle utilities documentation for information about using the TRUNCATE and REPLACE load methods.