BL_LOG= Data Set Option

Identifies a log file that will contain information such as statistics and error information for a bulk load.

Valid in: DATA and PROC steps
Supports: DB2 under UNIX and PC

Syntax

Syntax Description

path-and-log-filename

is a file to which information about the loading process is written.

Details

When the DB2 bulk-load facility is invoked, it creates a log file. The BL_ prefix distinguishes this log file from the one that was created by the SAS log. If BL_LOG= is specified with the same path and filename as an existing log, the new log replaces the existing log. If this option is not specified, the log that is created during the load operation is deleted immediately.
This option must be specified with the BULKOPTS= container option. The BULKLOAD= data set option must be set to YES.
bulkload=yes; bulkopts=(bl_log='c:\temp\bulkload.log');