BL_LOAD_METHOD= Data Set Option

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

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	INSERT when loading an empty table; APPEND when loading a table that contains data
Requirement:	To specify this option, you must first set BULKLOAD=YES.
Data source:	Oracle
See:	BULKLOAD= data set option

Syntax

Details

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 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

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.