158 BL_LOG= Data Set Option Chapter 10
Syntax
BL_LOAD_REPLACE= NO | YES
Syntax Description
NO
CLI LOAD interface appends new rows of data to the DB2 table.
YES
CLI LOAD interface replaces the existing data in the table.
BL_LOG= Data Set Option
Identifies a log file that contains information such as statistics and error information for a bulk load
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 UNIX/PC, Oracle, Teradata
Default value: DBMS-specific
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 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 BL_LOG is specified with the same path and filename as an
existing log, the new log replaces the existing log.
To specify this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165. See the documentation for your SAS/ACCESS interface for
additional details.
Oracle Details: When the SQL*Loader is invoked, it creates a log file. This file
contains a detailed summary of the load, including a description of any errors. If
SQL*Loader cannot create a log file, execution of the bulk load terminates. If a log file
does not exist, the default action is to create a log file in the current directory or the
default file specifications. If a log file already exists, the Oracle bulk loader reuses the
file, replacing the contents with information from the new load. On most platforms, the
default file name takes the form: BL_<table>_<unique-ID>.log, where
