Manualshelf

ALLBASE/SQL Reference Manual (36216-90216)

ManualsBrandsHP ManualsSoftwareMPE/iX 6.5 Operating System
571572573574575576577578579580
Chapter 12 575
SQL Statements S - Z
TERMINATE USER
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