15.00 - Error Table Formats - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

Error Table Formats

Table 24, the first error table, errortname1, has three columns:

 

Table 24: 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 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

Note: 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.