LOGOFF Command | Basic Teradata Query - LOGOFF - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Terminates the user's database sessions without exiting from BTEQ.

Syntax



Usage Notes

The LOGOFF command does not exit BTEQ. Use the EXIT or QUIT commands, which are synonymous within BTEQ, to exit BTEQ after logging off database user sessions.

  • For convenience in writing scripts, a suggested method is to use the EXIT command after an explicit LOGOFF command, and use the QUIT command when the LOGOFF command is not explicitly included.
  • The LOGOFF command is not valid in an SQL macro.

Example – LOGOFF

To log off all database user sessions, enter the following command:

.logoff