QUIT
Purpose
Logs off existing Teradata sessions and then exits from BTEQ.
Syntax
where:
|
Syntax Element |
Returns |
|
ACTIVITYCO |
The current value of the ACTIVITYCOUNT Unexpected results can occur for ACTIVITYCOUNT values greater than 2,147,483,647. status value |
|
ERRORCODE |
The error code generated by the last Teradata SQL request as the job step return code. |
|
ERRORLEVEL |
The highest user-assigned error severity level. |
|
n |
A decimal number specified as the job step return code. To avoid existing codes, do not use numbers from 1 to 10. |
Usage Notes
The BTEQ EXIT and QUIT commands are identical. For convenience in writing scripts, it might be preferred to use the EXIT command after a LOGOFF command and use QUIT if the LOGOFF command is not used.
The QUIT command cannot be used in a Teradata SQL macro.
The ERRORCODE value contains only the status of the last statement, even in a set of statements specified with the REPEAT command.
Example
To terminate a program and exit BTEQ, type:
.QUIT