Specifies the name and location of the data file that the DBMS server instance sees.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Alias: | BL_DATAFILE= |
| Default: | creates a data file 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). |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | DB2 under UNIX and PC Hosts, SAP IQ |
| See: | BL_CLIENT_DATAFILE= data set option, BL_DATAFILE= data set option, BL_REMOTE_FILE= data set option, BULKLOAD= data set option |
| Bulk Loading for DB2 under UNIX and PC Hosts, Bulk Loading for SAP IQ |
Table of Contents
specifies the fully qualified path name and file name of the data file to load, as seen by the DBMS server instance. By default, the base file name takes the form BL_<table>_<unique-ID>:
specifies the table name.
specifies a number that is used to prevent collisions in the event of two or more simultaneous bulk loadings of a particular table. The SAS/ACCESS engine generates the number.
DB2 under UNIX and PC Hosts: You must also specify a value for BL_REMOTE_FILE=. If the path to the data file from the DB2 server instance is different from the path to the data file from the client, you must use BL_SERVER_DATAFILE= to specify the path from the DB2 server. By enabling the DB2 server instance to directly access the data file that BL_DATAFILE= specifies, this option facilitates use of the DB2 LOAD command. For more information about the LOAD command, see the bulk-load topic in the DB2 under z/OS section. To specify the path from the client, see the BL_DATAFILE= data set option.
SAP IQ: To specify the path from the client, see the BL_CLIENT_DATAFILE= data set option, which is the client view of the data file.