Terminates the user's database sessions without exiting from BTEQ.
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: