BL_CLIENT_DATAFILE= Data Set Option

Specifies the client view of the data 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
Default: the temporary file directory that is specified by the UTILLOC= system option
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: SAP IQ
See: BULKLOAD= data set option

Table of Contents

Syntax

BL_CLIENT_DATAFILE=path-and-data-file-name

Syntax Description

path-and-data-file-name

specifies the file that contains the rows of data to load or append into a DBMS table during bulk loading. On most platforms, the default file name 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-loading operations on a particular table. The SAS/ACCESS engine generates the number.

dat

specifies the .dat file extension for the data file.

Last updated: February 3, 2026