Specifies override of the default delimiter character for separating columns of data during data transfer or retrieval 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_CONTROL_FIELD_DELIMITER |
| BL_DELIMITER | |
| BL_FIELD_DELIMITER | |
| Default: | , (comma) |
| 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, FIELD DELIMITED
BY field-delimiter is
added to the SAP HANA IMPORT statement. |
| See: | 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, BL_FILE_DELETE_DATAFILE= data set option, BULKLOAD= data set option |