Previous Page | Next Page

Data Set Options for Relational Databases


Specifies the name and location of the data file that the DBMS server instance sees.
Default value: creates a data file in the current directory or with the default file specifications (same as for BL_DATAFILE=)
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: DB2 under UNIX and PC Hosts, Sybase IQ

Syntax Description
See Also



Syntax Description


fully qualified pathname and filename of the data file to load, as seen by the DBMS server instance. By default, the base filename 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 loads of a particular table. The SAS/ACCESS engine generates the number.


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

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.

Sybase IQ: BL_CLIENT_DATAFILE= is the client view of the data file.

See Also

To specify the path from the client, see the BL_DATAFILE= Data Set Option [DB2 for UNIX and PC] or the BL_CLIENT_DATAFILE= Data Set Option.

BL_REMOTE_FILE= Data Set Option

BULKLOAD= Data Set Option

Bulk Loading for DB2 Under UNIX and PC Hosts

Previous Page | Next Page | Top of Page