Data Set Options for Relational Databases |
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
|
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
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.
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;
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.