Data Set Options for Relational Databases

ML_LOG= Data Set Option

Specifies a prefix for the names of the temporary tables that MultiLoad uses during a bulk-load operation.

Default value:	none
Valid in:	DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
DBMS support:	Teradata

Syntax
Syntax Description
Details
See Also

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

To specify this option, you must first set MULTILOAD=YES.

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.

Note: 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. [cautionend]

For more information about temporary table names that the Teradata MultiLoad utility uses and what is stored in each, see the Teradata MultiLoad reference.