BL_DEFAULT_DIR= Data Set Option

Specifies where bulk load creates all intermediate files.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: <database-name>
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: Oracle
See: BULKLOAD= data set option

Syntax

BL_DEFAULT_DIR=<host-specific-directory-path>

Required Argument

<host-specific-directory-path>
specifies the host-specific directory path where intermediate bulk-load files (CTL, DAT, LOG, BAD, DSC) are created

Details

The value that you specify for this option is prepended to the filename. Be sure to provide the complete, host-specific directory path, including the file and directory separator character to accommodate all platforms.

Example: Create All Files in a Temporary Directory

In this example, bulk load creates all related files in the C:\temp directory.
data x.test (bulkload=yes BL_DEFAULT_DIR="c:\temp\" bl_delete_files=no);
c1=1;
run;