Usage Notes - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

The following table describes the things to consider when using the LOGOFF command.

LOGOFF Usage Notes 
Topic Usage Notes
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.