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

Teradata® FastLoad Reference - 17.20

Product
FastLoad
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-11
dita:mapPath
dlf1641281592734.ditamap
dita:ditavalPath
vax1619194969834.ditaval

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.