Data Set Options for Relational Databases |
Sets the Oracle SQL*Loader DIRECT option.
Default value: |
YES
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Oracle
|
-
YES
-
sets the Oracle SQL*Loader option DIRECT
to TRUE, enabling the SQL*Loader to use Direct Path Load to insert rows into
a table.
-
NO
-
sets the Oracle SQL*Loader option DIRECT
to FALSE, enabling the SQL*Loader to use Conventional Path Load to insert
rows into a table.
To specify this option, you must first
set BULKLOAD=YES.
The Conventional Path Load reads in multiple data records
and places them in a binary array. When the array is full, it is passed to
Oracle for insertion, and Oracle uses the SQL interface with the array option.
The Direct Path Load creates data blocks that are already
in the Oracle database block format. The blocks are then written directly
into the database. This method is significantly faster, but there are restrictions.
For more information about the SQL*Loader Direct and Conventional Path loads,
see your Oracle utilities documentation for
SQL*Loader.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.