Error Table Formats | Teradata FastLoad - Error Table Formats - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
ije1544831946874.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table, the first error table, errortname1, has three columns:

errortname1 Columns 
Column Contains
DataParcel Entire data record, as provided by the source producer operator

DataParcel is used as the primary index for the first error table. The data record string can be up to 64,000 bytes, depending on which version of the the database the job is run against.

ErrorCode Database return code for the error condition, as specified in Teradata Vantage™ - Database Messages, B035-1096
ErrorFieldName Name of the data item that caused the error condition, as specified in the fieldname attribute of the DEFINE command in the Teradata FastLoad job script
If the length of the data item name is greater than 120 characters, the database truncates the data item name to the length of 120 characters.

The format of the second error table, errortname2, is identical to that of the Teradata FastLoad target table.