16.20 - Accessing Error Tables - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Error tables are stored in the Teradata Database. The following SQL requests access to the error tables shown in the in the examples in Reading Error Tables:

ErrorTable1

SELECT errorcode, errorfield, sourceseq, dmlseq from t2_e1;

If the operator definition does not specify a name for the ErrorTable1 attribute, the error table will be named <TargetTableName>_ET by default.

If the Stream operator AppendErrorTable attribute is set to Yes, the Stream errors for the current job may be found in a table with errors from one or more previous jobs.

ErrorTable2

SELECT dbcerrorcode, sourceseq, dmlseq FROM t3_e2;

If the operator definition does not specify a name for the ErrorTable2 attribute, the error table will be named <TargetTableName>_UV by default.

When accessing error tables, you may find it useful to add the expression ORDER BY ErrorCode.