142 BL_DATAFILE= Data Set Option Chapter 10
BL_DATAFILE= Data Set Option
Identifies the file that contains the data from the SAS data set that is loaded or appended into a
DBMS table during a bulk load
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
Oracle, DB2 UNIX/PC
Default value:
creates a data file in the current directory or with the default file
specifications
Syntax
BL_DATAFILE= path-and-data-filename
Syntax Description
path-and-data-filename
is a file that contains the rows of data to be loaded. On most platforms, the default
file name takes the form BL_<table>_<unique-ID>.ext, where
table is the table name
unique-ID is a number used to prevent collisions in the event of two or more
simultaneous bulk loads of a particular table. The SAS/ACCESS engine
generates the number.
ext is the file extension (.DAT or .IXF) for the data file.
Details
The SAS/ACCESS engine creates this data file from the input SAS data set before
calling the bulk loader. The data file contains SAS data that is ready to load into the
DBMS.
By default, the data file is deleted after the load is completed. To override this
behavior, specify BL_DELETE_DATAFILE= NO.
To specify this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165.
Oracle Details: If you do not specify this option and a data file does not exist, the
default action is to create a file in the current directory (or with the default file
specifications). If you do not specify this option and a data file already exists,
SAS/ACCESS reuses the file, replacing the contents with the new data. The exception
to this is the interface to Oracle on the OS/390 platform, where the data file is never
reused. The interface to Oracle on OS/390 will fail a bulk load rather than reuse a data
file.
BL_DB2DEVT_PERM= Data Set Option
Specifies the unit address or generic device type that is used for the permanent data sets created
by the LOAD utility, as well as SYSIN, SYSREC, and SYSPRINT when they are allocated by SAS
