Data Set Options for Relational Databases

BL_CLIENT_DATAFILE= Data Set Option

Specifies the client view of the data file that contains DBMS data for bulk load.

Default value:	the current directory
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Sybase IQ

Syntax
Syntax Description
Details
See Also

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.

Details

To specify this option, you must first set BULKLOAD=YES.