Data Set Options for Relational Databases |
Specifies the name of a
temporary table that MultiLoad uses to
track errors that were generated during the application phase of 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
|
ML_ERROR2=temporary-table-name
|
- temporary-table-name
-
specifies the name of a temporary table that MultiLoad uses
to track errors that were generated during the application phase of a bulk-load
operation.
To specify this option, you must first set MULTILOAD=YES.
Use this option to specify the name of a table to use for tracking errors
that were generated during the application phase of the MultiLoad bulk-load
operation. By default, the application error table is named SAS_ML_UT_randnum, where randnum is a random
number.
When you restart a failed MultiLoad job, you must specify the same application
table from the earlier run so that the MultiLoad job can restart correctly.
Using ML_RESTART=, ML_ERROR1=, and ML_WORK=, you must also specify the same
log table, acquisition error table, and work table upon restarting.
Note: Do not use ML_ERROR2 with ML_LOG=, which provides a common prefix
for all temporary tables that the Teradata MultiLoad utility uses. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
For more information about temporary table names that the Teradata MultiLoad
utility uses and what is stored in each, see the Teradata MultiLoad reference.
To specify a common prefix for all temporary tables that
the Teradata
MultiLoad utility uses, see the
ML_LOG= Data Set Option.
ML_ERROR1= Data Set Option
ML_RESTART= Data Set Option
ML_WORK= Data Set Option
MULTILOAD= Data Set Option
Using MultiLoad
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.