BL_LOG= Table Option

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

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

Syntax

BL_LOG= "path-and-log-file-name"

Arguments

path-and-log-file-name

is a file to which information about the loading process is written. The default path and log filename is DBMS-specific.

Details

When the DBMS bulk load facility is invoked, it creates a log file. The contents of the log file are DBMS-specific. The BL_ prefix distinguishes this log file from the one created by the SAS log. If the BL_LOG= table option is specified with the same path and filename as an existing log, the new log replaces the existing log.
If the BL_LOG= table option is not specified, the log file is deleted automatically after a successful operation.

Example

The BL_LOG= table option is specified within the BL_BULKOPTS= table option: 
bulkload=yes; bulkopts=(bl_log="c:\temp\bulkload.log");

See Also

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