BL_REMOTE_FILE= Table Option

Specifies the base filename and location of DB2 LOAD temporary files.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC
Syntax
Arguments
Details
See Also

Syntax

BL_REMOTE_FILE= pathname-and-base-filename

Arguments

pathname-and-base-filename

specifies 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, BL_<table>_<unique-ID> is the form of the base filename.

table

specifies the table name.

unique-ID

specifies a number that prevents collisions in the event of two or more simultaneous bulk loads of a particular table. The table driver generates this number.

Details

When you specify this option, the DB2 LOAD command is used (instead of the IMPORT command).
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

Table Options:
BULKLOAD= Table Option
Copyright © SAS Institute Inc. All rights reserved.