Specifies the name of a temporary table that non-TPT MultiLoad uses to track errors that were generated during the acquisition phase of bulk-loading.
| Valid in: | DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Restrictions: | Starting in SAS 9.4M9, this option is no longer used. In SAS 9.4M9, use TPT_ERROR_TABLE_1=. |
| 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 specify 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_ERROR2= data set option, ML_LOG= data set option, ML_RESTART= data set option, ML_WORK= data set option, MULTILOAD= data set option, Teradata MultiLoad documentation, TPT_ERROR_TABLE_1= data set option, Using MultiLoad |
Table of Contents
specifies the name of a temporary table that non-TPT MultiLoad uses to track errors that were generated during the acquisition phase of bulk loading.
Use this option to specify the name of a table to use for tracking errors that were generated during the acquisition phase of non-TPT MultiLoad bulk loading. By default, the acquisition error table is named SAS_ML_ET_randnum, where randnum is a random number.