Data Set Options for Relational Databases |
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
|
BL_LOAD_METHOD=INSERT | APPEND | REPLACE | TRUNCATE
|
-
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.
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.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.