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

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

Purpose

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

Syntax


LOGOFF 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