Optional Completion Code |
Specify the optional completion code value, retcode, as a conditional or an arithmetic expression, evaluated to a single integer. The LOGOFF command is processed when the highest return code reached prior to the LOGOFF command is no more than 4 (warning). Any higher return code would have already terminated the Teradata MultiLoad job.
If the LOGOFF command is processed, Teradata MultiLoad returns the higher of:
- The retcode value specified as a LOGOFF command option
- The highest return code reached prior to the LOGOFF command
For example, if the retcode value was specified as 2, but a warning had occurred earlier in the run, Teradata MultiLoad would return 4, not 2.
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.
|
Termination Return Codes |
When a Teradata MultiLoad job terminates and an optional retcode value has not been specified, the utility returns a code indicating the way the job completed:- Code 0—Normal completion. The job completed successfully and according to the specified plan.
- Code 4—Warning. A warning condition occurred; for example, a job deviated from normal or from the specified plan, but still completed successfully. A warning may indicate deviation from the plan; for example, the number of sessions specified were not actually used, or a part of the job did not run. Warning conditions do not terminate the job.
- Code 8—User error. A user error, such as a syntax error in the job script, terminated the job.
- Code 12—Severe error. A fatal error terminated the job. A fatal error is any error other than a user error.
- Code 16—No message destination is available.
|
When Permitted |
The LOGOFF command is permitted at any point in the input script. It logs users off immediately. |