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 UNIX/PC

Syntax

BL_LOG=path-and-log-filename

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 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');