Data Set Options for Relational Databases |
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_ERROR1=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 |
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 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.
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.
Note: 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.
For more information about temporary table names that the Teradata MultiLoad utility uses and what is stored in each, see the Teradata MultiLoad reference.
See Also |
To specify a common prefix for all temporary tables that the Teradata MultiLoad utility uses, see the ML_LOG= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.