The first error table, called the acquisition error table, is the one specified as tname3 (default ET_tname1) in the BEGIN MLOAD command. It provides information about:
- All errors that occur during the acquisition phase of the Teradata MultiLoad job
- Some errors that occur during the application phase if the database cannot build a valid primary index
The following table shows the format of the acquisition error table.
| Column | Contains |
|---|---|
| ApplySeq | Sequence number of the APPLY clause that was executing when the error occurred |
| DMLSeq | Sequence number assigned to the DML statement in which the error occurred |
| ErrorCode | Code for the error |
| ErrorField | Field name of the target table in which the error occurred This field may be blank if the system cannot determine which field caused the problem. Error 2677 (stack overflow) is an example of such a condition. |
| HostData | Client data that was being processed when the error occurred |
| ImportSeq | Sequence number assigned to the IMPORT command in which the error occurred |
| SMTSeq | Sequence number of the statement that was being executed when the error occurred |
| SourceSeq | Data row number in the client file that the database was building when the error occurred |