Error Table Formats - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-18
dita:mapPath
tjz1488824663315.ditamap
dita:ditavalPath
Audience_PDF_include.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 DBS the job is run against.

ErrorCode Teradata Database return code for the error condition, as specified in the Messages manual (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 DBS will truncate 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.