EXIT
Purpose
Logs off all Teradata Database sessions and exits 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. |
ERRORCODE |
The error code generated by the last Teradata SQL request as the job step return code |
ERRORLEVEL |
The highest error severity level assigned by the user. |
n |
A decimal number as the job step return code. To avoid existing codes, do not use numbers 1 through 10. |
Usage Notes
The BTEQ EXIT and QUIT commands are identical. For convenience in writing scripts, it might be preferable to use the EXIT command after an explicit LOGOFF command and use QUIT if the LOGOFF command is not explicitly provided.
The EXIT 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 exit BTEQ, type:
.EXIT