EXIT - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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