Specifies the base file name and location of DB2 LOAD temporary files.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | none |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | DB2 under UNIX and PC Hosts |
| See: | BL_SERVER_DATAFILE= data set option (specifies the path from the server), BULKLOAD= data set option, DB2 under z/OS Bulk Loading |
Table of Contents
the full path name and base file name 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 file name.
specifies the table name.
specifies a number that prevents collisions in the event of two or more simultaneous bulk loadings of a particular table. The SAS/ACCESS engine generates this number.
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 path name, 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 path name-and-base-file-name value.