HP 3000 Manuals

ALLBASE/SQL Reference Manual

TERMINATE USER 

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 

                        {DBEUserID       }
[REV BEG]TERMINATE USER {SessionID       }
                        {CID ConnectionID}
[REV END]

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.[REV BEG]

CID ConnectionID        identifies the specific connection to
                        terminate.[REV END]

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 'PartsDBE.SomeGrp.SomeAcct'

     User1 starts a DBE session SessionID2 

     CONNECT TO 'PartsDBE.SomeGrp.SomeAcct'

     User2 starts a DBE session SessionID3 

     CONNECT TO 'PartsDBE.SomeGrp.SomeAcct'

     User2 starts a DBE session SessionID4 

     CONNECT TO 'PartsDBE.SomeGrp.SomeAcct'

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 

MPE/iX 5.5 Documentation