ML_LOG= Data Set Option

Specifies a prefix for the names of the temporary tables that MultiLoad uses during a bulk-load operation.
Valid in: DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
Default: none
Restriction: Do not use ML_LOG= with ML_RESTART=, ML_ERROR1=, ML_ERROR2=, or ML_WORK= because ML_LOG= provide specific names to the temporary files.
Requirement: To specify this option, you must first set MULTILOAD=YES.
Data source: Teradata
See: ML_ERROR1= data set option, ML_ERROR2= data set option, ML_RESTART= data set option, ML_RESTART= data set option, ML_WORK= data set option, MULTILOAD= data set option, Using MultiLoad

Syntax

ML_LOG=prefix-for-MultiLoad-temporary-tables

Syntax Description

prefix-for-MultiLoad-temporary-tables
specifies the prefix to use when naming Teradata tables that the Teradata MultiLoad utility uses during a bulk-load operation.

Details

You can use this option to specify a prefix for the temporary table names that the MultiLoad utility uses during the load process. The MultiLoad utility uses a log table, two error tables, and a work table while loading data to the target table. By default, here are the names for these tables, where randnum is a random number.
Temporary Table
Table Name
Restart table
SAS_ML_RS_randnum
Acquisition error table
SAS_ML_ET_randnum
Application error table
SAS_ML_UT_randnum
Work table
SAS_ML_WT_randnum
To override the default names, here are the table names that would be generated if ML_LOG=MY_LOAD, for example.
Temporary Table
Table Name
Restart table
MY_LOAD_RS
Acquisition error table
MY_LOAD_ET
Application error table
MY_LOAD_UT
Work table
MY_LOAD_WT
SAS/ACCESS automatically deletes the error tables if no errors are logged. If there are errors, the tables are retained, and SAS/ACCESS issues a warning message that includes the names of the tables in error.
For more information about temporary table names that the Teradata MultiLoad utility uses and what is stored in each, see the Teradata MultiLoad reference.