Termination Return Codes
When a Teradata TPump job terminates, it returns a completion code to the client system.
Table 21 lists the conventions used.
Code |
Description |
0 |
Normal completion |
4 |
Warning |
8 |
User error |
12 |
Severe internal error |
16 |
No message destination is available |
Note: Teradata TPump continues receiving all Teradata Database warnings. The return code is 4. To avoid ambiguous or conflicting results, always use values greater than 20 when specifying a return code with the LOGOFF command.
Many CLI and Teradata Database errors generate return codes of 12. For Teradata Database errors that can be corrected and resubmitted, Teradata TPump tries up to 16 times to resubmit and, at the end of this process, returns a code of 12. Many CLI and Teradata Database errors generate the return code of 12, except for: