BL_CONTROL_RECORD_DELIMITER= Data Set Option

Specifies the single delimiter character to use to separate SAP HANA table records.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Aliases: BL_CONTROL_RECORD_DELIMITER
BL_RECORD_DELIMITER
Default: '\n' (new line)
Range: You can specify any single-character.
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: SAP HANA
Note: When you specify this option, RECORD DELIMITED BY record-delimiter is added to the SAP HANA IMPORT statement.
See: BL_CONTROL_FIELD_DELIMITER= data set option, BL_CONTROL_QUOTATION_MARK= 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, BL_FILE_DELETE_DATAFILE= data set option, BULKLOAD= data set option

Syntax

BL_CONTROL_RECORD_DELIMITER='<record-delimiter>'
Last updated: February 3, 2026