ALLBASE/SQL Reference Manual > Chapter 12 SQL Statements S - Z

TERMINATE USER

	MPE documents
	Complete PDF
	Table of Contents
	Index

	E0300 Edition 9 ♥
	E0399 Edition 8
	E0897 Edition 7

The TERMINATE USER statement terminates one or more DBE sessions associated with your user name or another user name.

Scope

ISQL or Application Programs

SQL Syntax


  TERMINATE USER {DBEUserID
                  SessionID
                  CID ConnectionID}

Parameters

DBEUserID: identifies the user to terminate all sessions for. Users currently on the system appear in the system view SYSTEM.USER.
SessionID: identifies a specific session to be terminated. Session identifiers can be found in the system view SYSTEM.USER. One user may have several session IDs active at the same time.
CID ConnectionID: identifies the specific connection to terminate.

Description

Any transactions in progress in the session(s) are terminated and any changes are backed out. Any locks still held are released, and any cursor still open is closed.

Authorization

You can terminate a session if it is your own session, or if you have DBA authority.

Example


   User1 starts a DBE session SessionID1

   CONNECT TO '../sampledb/PartsDBE'

   User1 starts a DBE session SessionID2

   CONNECT TO '../sampledb/PartsDBE'

   User2 starts a DBE session SessionID3

   CONNECT TO '../sampledb/PartsDBE'

   User2 starts a DBE session SessionID4

   CONNECT TO '../sampledb/PartsDBE'

Both of User1's DBE sessions terminate. Either User1 or a DBA can enter this statement.


   TERMINATE USER User1

One of User2's DBE sessions terminates. Either User2 or a DBA can enter this statement.


   TERMINATE USER SessionID3

TERMINATE TRANSACTION

TRANSFER OWNERSHIP