QUIT - FastLoad

Purpose  

The QUIT command ends Teradata FastLoad sessions and exits from the Teradata Database.

The LOGOFF and QUIT commands may be used interchangeably.

Syntax  

Usage Notes

Table 46 describes the things to consider when using the QUIT command. For more information about restarting a paused job, see “Restart a Paused Teradata FastLoad Job” on page 46.

Table 46: Usage Notes for QUIT 

Topic	Usage Notes
Pausing Teradata FastLoad	If the QUIT 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 Teradata Database locks the tables named in the BEGIN LOADING command. The tables remain locked until an END LOADING command is entered.
Terminating 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. Warning conditions do not terminate the job. Code 8—User error. A user error, such as a syntax error in the Teradata FastLoad job script, terminated the job. Code 12—Fatal error. Job is terminated. A fatal error is any error other than a user error.

Example  

The following command example ends Teradata FastLoad and exits the Teradata Database:

QUIT ;

The completion message indicates that the Teradata FastLoad job was either paused or terminated, depending on whether the job was in the loading phase or not:

If the job is in the loading phase, then Teradata FastLoad responds:

*** 16:09:18 Logging off all sessions

*** 16:09:21 Total processor time used = '0.374402 Seconds'

    .        Start : Fri Jan 10 16:08:59 2014

    .        End   : Fri Jan 10 16:09:21 2014

    .        Highest return code encountered = '4'.

*** 16:09:21 FastLoad Paused

If the job is not in the loading phase, then Teradata FastLoad responds:

**** 16:11:42 Logging off all sessions

**** 16:11:45 Total processor time used = '0.358802 Seconds'

     .        Start : Fri Jan 10 16:11:20 2014

     .        End   : Fri Jan 10 16:11:45 2014

     .        Highest return code encountered = '0'.

**** 16:11:45 FDL4818 FastLoad Terminated