Data Set Options for Relational Databases BL_SQLLDR_PATH= Data Set Option 163
BL_SERVER_DATAFILE= Data Set Option
Specifies the name and location of the data file as seen by the DB2 server instance
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 UNIX/PC
Default value:
same as BL_DATAFILE
Syntax
BL_SERVER_DATAFILE=path-and-data-filename
Syntax Description
pathname-and-data-filename
is the fully-qualified pathname and filename of the data file to be loaded, as seen by
the DB2 server instance. By default, the base filename takes the form
BL_<table>_<unique-ID>, where
table is the table name
unique-ID is a number 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
If the path to the data file from the DB2 server instance is different than 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 specified by
BL_DATAFILE, this option facilitates use of the DB2 LOAD command. See the bulk
loading topic in the SAS/ACCESS documentation for DB2 UNIX/PC for more
information about the LOAD command.
To specify this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165 and specify a value for “BL_REMOTE_FILE= Data Set Option”
on page 162.
See Also
To specify the path from the client, see “BL_DATAFILE= Data Set Option” on page
142.
BL_SQLLDR_PATH= Data Set Option
Specifies the location of the SQLLDR executable file
