Previous Page | Next Page

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.


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