Data Set Options for Relational Databases

BL_DIRECT_PATH= Data Set Option

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

Syntax
Syntax Description
Details
See Also

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

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.