ML_ERROR1= Data Set Option

Specifies the name of a temporary table that MultiLoad uses to track errors that were generated during the acquisition phase of 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_ERROR1 with the ML_LOG= data set option. ML_LOG= provides a common prefix for all temporary tables that the Teradata MultiLoad utility uses.
Requirements: To specify this option, you must first set MULTILOAD=YES.

When you restart a failed MultiLoad job, you must specify the same acquisition table from the earlier run so that the MultiLoad job can restart correctly. Using ML_RESTART=, ML_ERROR2=, and ML_WORK=, you must also specify the same log table, application error table, and work table upon restarting.

Data source: Teradata
See: ML_LOG= data set option, ML_ERROR2= data set option, ML_RESTART= data set option, ML_WORK= data set option, MULTILOAD= data set option, Using MultiLoad

Syntax

ML_ERROR1=temporary-table-name

Syntax Description

temporary-table-name
specifies the name of a temporary table that MultiLoad uses to track errors that were generated during the acquisition phase of a bulk-load operation.

Details

Use this option to specify the name of a table to use for tracking errors that were generated during the acquisition phase of the MultiLoad bulk-load operation. By default, the acquisition error table is named SAS_ML_ET_randnum, where randnum is a random number.
For more information about temporary table names that the Teradata MultiLoad utility uses and what is stored in each, see the Teradata MultiLoad reference.