Usage Notes - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-10
dita:mapPath
lsl1527114222348.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
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.