BL_DATAFILE=

BL_DATAFILE=

Determines the name and location of the data file.

Default value: creates a data file in the current directory.

Syntax

BL_DATAFILE=path-and-data-filename

path-and-data-filename: An SQL*Loader file that contains the rows of data to be loaded. You can specify the full path and filename in this argument, or use the default file name and location. The default action is to create a bl_<tablename>.dat file in the current directory.

The SAS/ACCESS engine for ORACLE creates this data file from the input SAS data set. It contains SAS data that is ready to load into ORACLE.

To specify BL_DATAFILE=, you must first specify YES for the option BULKLOAD=.