Data Set Options for Relational Databases

BL_DEFAULT_DIR= Data Set Option

Specifies where bulk load creates all intermediate files.

Default value:	<database-name>
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Oracle

Syntax
Details
Example
See Also

Syntax

BL_DEFAULT_DIR=<host-specific-directory-path>

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

Details

To specify this option, you must first set BULKLOAD=YES.

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

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;