Previous Page | Next Page

Data Set Options for Relational Databases

BL_REMOTE_FILE= Data Set Option



Specifies the base filename and location of DB2 LOAD temporary files.
Default value: none
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: DB2 under UNIX and PC Hosts

Syntax
Syntax Description
Details
See Also

Syntax

BL_REMOTE_FILE=pathname-and-base-filename

Syntax Description

pathname-and-base-filename

is the full pathname 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 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.

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 a DB2 client or server before Release 6.1 might cause the tablespace to become unusable in the event of a load error. A load error might affect tables other than the table being loaded.

When you specify this option, the DB2 LOAD command is used (instead of the IMPORT command). For more information about these commands, see the bulk-load topic in the DB2 under z/OS section.

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.


See Also

To specify the path from the server, see the BL_SERVER_DATAFILE= Data Set Option.

BULKLOAD= Data Set Option

Bulk Loading for DB2 Under UNIX and PC Hosts

Previous Page | Next Page | Top of Page