BL_CLIENT_DATAFILE= Data Set Option
Specifies the client view of the data file that
contains DBMS data for bulk load.
| Valid in: |
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
|
| Default: |
the current directory |
| Requirement: |
To specify this option, you must first set BULKLOAD=YES. |
| Data source: |
Sybase IQ |
| See: |
BULKLOAD= data set option |
Syntax
BL_CLIENT_DATAFILE=path-and-data-filename
Syntax Description
- path-and-data-filename
-
specifies the file
that contains the rows of data to load or append into a DBMS table
during bulk load. On most platforms, the default filename takes the
form BL_<table>_<unique-ID>.dat:
- table
-
specifies the table
name.
- unique-ID
-
specifies a number
that is used to prevent collisions in the event of two or more simultaneous
bulk loads of a particular table. The SAS/ACCESS engine generates
the number.
- dat
-
specifies the .DAT
file extension for the data file.