Optional Completion Code |
The optional completion code value,retcode, can be specified as a conditional or an arithmetic expression, evaluated to a single integer. The LOGOFF command processes whenever the highest return code reached was no more than 04 (warning). Any return code other than 00 or 04 terminates the FastExport job.
If a serious error terminates the program before the LOGOFF command is processed, the return code output is the value generated by the error condition rather than the retcode value specified as a LOGOFF command option.
|
Terminating Return Codes |
When a FastExport job terminates, and an optional retcode value is not specified, the utility returns a code indicating the way the job completed:- Code 0 – job completed normally
- Code 4 – a warning condition occurred. Warning conditions do not terminate the job.
- Code 8 – a user error, such as a syntax error in the FastExport job script, terminated the job
The following Database error messages produce a return code of 08: 3600 3692 3695
- Code 12 – a fatal error terminated the job. A fatal error is any error other than a user error.
- Code 16 – no message destination is available
For a complete description of Database error messages, refer to Teradata Vantage™ - Database Messages, B035-1096.
|
When Permitted |
The LOGOFF command is permitted at any point in the input script. It logs off immediately. |
Automatic Logoff |
FastExport performs an automatic logoff function if:- All of the export data from the database has been processed without encountering a LOGOFF command
- The program fails because of an error
|