Identifies the file that contains control statements.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Aliases: | BL_CONTROL |
| BL_CONTROLFILE | |
| BL_FILE_CONTROLFILE | |
| Default: | default-dir/BL_table_name_number.ctl |
| 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 control 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_DATAFILE= data set option, BL_FILE_DEFAULT_DIR= data set option, BL_FILE_DELETE_DATAFILE= data set option, BULKLOAD= data set option |
The SAP HANA interface creates the control file by using information from the input data and SAS/ACCESS options. The file contains Data Definition Language (DDL) definitions that specify the location of the data and how the data corresponds to the database table. It is used to specify exactly how the loader should interpret the data that you are loading from the DATA file (.dat file).
By default, SAS/ACCESS creates a control file in the temporary file directory that the UTILLOC= system option specifies or in another directory based on your default file specifications. If you do not specify this option and a control file does not already exist, a file is created in the temporary file directory (or in another directory that is based on your default file specifications). If you do not specify this option and a control file already exists, the SAP HANA interface reuses the file and replaces the contents with the new control statements.