BL_SERVER_DATAFILE= Data Set Option

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)
Alias:	BL_DATAFILE
Default:	creates a data file in the current directory or with the default file specifications (same as for BL_DATAFILE=)
Requirement:	To specify this option, you must first set BULKLOAD=YES.
Data source:	DB2 under UNIX and PC Hosts, Sybase IQ
See:	BL_CLIENT_DATAFILE= data set option [Sybase IQ], BL_DATAFILE= data set option [DB2 for UNIX and PC Hosts], BL_REMOTE_FILE= data set option, BULKLOAD= data set option, Bulk Loading for DB2 under UNIX and PC Hosts

Syntax

Details

Syntax

BL_SERVER_DATAFILE=path-and-data-filename

Syntax Description

pathname-and-data-filename

specifies the 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>:

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.

Details

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.

Sybase 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.