BL_FILE_BADFILE= Data Set Option

Identifies a file that contains records that were rejected during bulk loading.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Aliases: BL_ERRORFILE
BL_BADFILE
BL_FILE_BADFILE
BL_FILE_LOG
BL_LOG
Default: none
Restriction: For use with a distributed system, this file name must point to a shared disk.
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: SAP HANA
Note: Use this option to specify the fully qualified file name for the temporary error file.
See: BL_CONTROL_FIELD_DELIMITER= data set option, BL_CONTROL_QUOTATION_MARK= data set option, BL_CONTROL_RECORD_DELIMITER= data set option, BL_FILE_CONTROLFILE= data set option, BL_FILE_DATAFILE= data set option, BL_FILE_DEFAULT_DIR= data set option, BL_FILE_DELETE_DATAFILE= data set option, BULKLOAD= data set option

Syntax

BL_FILE_BADFILE=default-dir/BL_table_name_number.err
Last updated: February 3, 2026