16.10 - ErrorTable2 - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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.