BL_FILE_DELETE_DATAFILE= Data Set Option

Specifies whether to delete only the data file or all files that the SAS/ACCESS engine creates for the DBMS bulk-load facility.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Aliases: BL_DELETE_DATAFILE
BL_FILE_DELETE_DATAFILE
Default: YES
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: SAP HANA
See: BL_CONTROL_FIELD_DELIMITER= data set option, BL_CONTROL_QUOTATION_MARK= data set option, BL_CONTROL_RECORD_DELIMITER= data set option, BL_FILE_BADFILE= data set option, BL_FILE_CONTROLFILE= data set option, BL_FILE_DATAFILE= data set option, BL_FILE_DEFAULT_DIR= data set option, BULKLOAD= data set option

Table of Contents

Syntax

BL_FILE_DELETE_DATAFILE=YES | NO

Syntax Description

YES

deletes the data file that the SAS/ACCESS engine creates for the DBMS bulk-load facility.

NO

does not delete the file.

Last updated: February 3, 2026