Identifies the file that contains DBMS data for bulk loading.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Alias: | BL_DATAFILE |
| 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 data 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_BADFILE= data set option, BL_FILE_CONTROLFILE= data set option, BL_DELETE_DATAFILE= data set option, BL_FILE_DEFAULT_DIR= data set option, BL_FILE_DELETE_DATAFILE= data set option, BULKLOAD= data set option |
By default, the SAP HANA interface creates a data file with a DAT file extension in the temporary file directory that is specified by the UTILLOC= system option (or in another directory that is based on your default file specifications). In addition, by default, the data file is deleted after the load is completed. To override this behavior, specify BL_DELETE_DATAFILE=NO.