162 BL_REMOTE_FILE= Data Set Option Chapter 10
allows the LOAD process to be recoverable and the copy location for the data should
be specified by BL_COPY_LOCATION
NO
specifies that the LOAD process is not recoverable.
BL_REMOTE_FILE= Data Set Option
Specifies the base file name and location of DB2 Loader temporary files
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 UNIX/PC
Default value:
none
Syntax
BL_REMOTE_FILE=pathname-and-base-filename
Syntax Description
pathname-and-base-filename
is the full path name and base filename to which DB2 appends extensions (such as
.log, .msg, and .dat files) to create temporary files during load operations. By default,
the base file name 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
When you specify this option, the DB2 LOAD command is used (instead of the IMPORT
command). See the bulk loading topic in the SAS/ACCESS documentation for DB2
UNIX/PC for more information about these commands.
For pathname, specify a location on a DB2 server that is accessed exclusively by a
single DB2 server instance, and for which the instance owner has read and write
permissions. Make sure that each LOAD command is associated with a unique
pathname-and-base-filename value.
To specify this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165.
Note: Do NOT use BL_REMOTE_FILE= unless you have SAS Release 6.1 or later
for both the DB2 client and server. Using the LOAD facility with DB2 client or server
prior to Release 6.1 might cause the tablespace to become unusable in the event of a
load error. This might affect tables other than the table being loaded.
