LOGOFF | Usage Notes | Teradata FastLoad - 17.10 - Usage Notes - FastLoad

Teradata® FastLoad Reference

Release Number
June 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)

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

LOGOFF Command Usage Notes 
Topic Usage Notes
Pausing Teradata FastLoad If the LOGOFF command is entered after a BEGIN LOADING command, but before the END LOADING command, the Teradata FastLoad job pauses and can be restarted later.
Locked Tables When a Teradata FastLoad job pauses during the loading phase, the database locks the tables named in the BEGIN LOADING command. The tables remain locked until an END LOADING command is entered.
Termination Return Codes When a Teradata FastLoad job terminates, 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.