Normal Termination - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

Including the Teradata MultiLoad LOGOFF command in a Teradata MultiLoad job script terminates the utility normally on both workstation-attached and mainframe-attached client systems. The following syntax diagram illustrated the command.



Teradata MultiLoad logs off all sessions with the database and returns a status message indicating:
  • The total processor time that was used
  • The job start and stop date/time
  • The highest return code (termination return code) that was encountered:
    • 0 if the job completed normally
    • 4 if a warning condition occurred
    • 8 if a user error occurred
    • 12 if a fatal error occurred
    • 16 if no message destination is available
Teradata MultiLoad also:
  • Either maintains or drops the restart log table, depending on the success or failure of the job.
  • If specified, returns the optional retcode value to the client operating system.

For more information about return codes and the conditions that maintain or drop the restart log table, see LOGOFF.