Data Set Options for Relational Databases

BL_SERVER_DATAFILE= Data Set Option

Specifies the name and location of the data file that the DBMS server instance sees.

Alias:	BL_DATAFILE
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
Syntax Description
Details
See Also

Syntax

BL_SERVER_DATAFILE=path-and-data-filename

Syntax Description

pathname-and-data-filename

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

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.