ErrorTable2 - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

Load operations create a duplication error table that captures errors during job runs. Jobs can use the default names of the error tables, or names can be user-specified as an attribute of the Load operator.

If you specify a name for ErrorTable2, the system creates the table in the default database for the logon user, unless a different database is specified in the WorkingDatabase attribute.

If you do not specify a name for ErrorTable2, the system default name for ErrorTable2 is based on the TargetTable name. The system names the table using the form ttname_UV and creates the table in the database that contains the TargetTable, unless a different database is specified in the WorkingDatabase attribute. This error table is not used when the target table has a non-unique primary index.