BL_DELETE_DATAFILE=

BL_DELETE_DATAFILE=

Deletes the data file created for SQL*Loader.

Default value: YES

Syntax

Syntax

BL_DELETE_DATAFILE=YES | NO

YES: Deletes the data file ( .dat file) that the SAS/ACCESS engine created for SQL*Loader.
NO: Saves the data file from deletion.

Details

Setting the BL_DELETE_DATAFILE= option to YES deletes the temporary data file that is created after the load is completed. Only the data file is deleted; other files, such as the control, log, discard, and bad files, are not deleted.

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

Chapter Contents
Previous
Next
Top of Page