Purpose
It terminates the user's database sessions without exiting from BTEQ.
Syntax
| Command | Shorthand |
|---|---|
| LOGOFF | LO |
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