Identifies a log file that contains information for bulk loading, such as statistics and errors.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | DBMS-specific |
| Restriction: | Teradata: Starting in SAS 9.4M9, this option is no longer used. |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | DB2 under UNIX and PC Hosts, Microsoft SQL Server, Oracle, Teradata |
| Note: | Support for Microsoft SQL Server was added in SAS 9.4M7. |
| See: | BL_LOG= LIBNAME option, BULKLOAD= data set option, DB2 under UNIX and PC Hosts Bulk Loading, LOGDB= LIBNAME option, Maximizing Teradata Load Performance (Teradata bulk loading) |
Table of Contents
specifies a file where information about the loading process is written.
See the reference section for your SAS/ACCESS interface for additional details about specifying this option.
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 file name as an existing log, the new log replaces the existing log.
DB2 under UNIX and PC Hosts: If BL_LOG= is not specified, the log file is created in the temporary file directory that is specified by the UTILLOC= system option. For more information, see the bulk-load topic in the DB2 under UNIX and PC Hosts bulk-load section.
Microsoft SQL Server: The BL_LOG= value is used with the COPY command in Azure Synapse Analytics (SQL DW). This functionality is supported when you are using an Azure Data Lake Gen2 account.
Oracle: 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 loading terminates. If a log file does not already exist, it is created in the temporary file directory that is specified by the UTILLOC= system option (or in another directory that is based on your default file specifications). If a log file does already exist, the SQL*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:
specifies the table name
specifies a number that is used to prevent collisions in the event of two or more simultaneous bulk loadings of a particular table. The SAS/ACCESS engine generates the number.
Teradata: This option is used with the non-TPT FastLoad utility only. Starting in SAS 9.4M9, SAS/ACCESS no longer supports non-TPT FastLoad. For this reason, this option is not used in SAS 9.4M9. Documentation remains for users who have not upgraded to SAS 9.4M9 or later. As an alternative, you can use the LOGDB= LIBNAME option with TPT FastLoad.