Data Set Options for Relational Databases BL_DIRECT_PATH= Data Set Option 153
Syntax Description
YES
deletes the data file that the SAS/ACCESS engine creates for the DBMS bulk load
facility.
NO
saves the data file from deletion.
Details
Setting the BL_DELETE_DATAFILE= option to YES deletes the temporary data file
that is created after the load is completed. Only the data file is deleted.
To specify this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165.
BL_DIRECT_PATH= Data Set Option
Sets the Oracle SQL*Loader DIRECT option
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
Oracle
Default value: YES
Syntax
BL_DIRECT_PATH= YES | NO
Syntax Description
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.
Details
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 the Oracle utilities documentation
for SQL*Loader.
