 |
» |
|
|
|
SYSTEM.USER is a pseudotable that contains a row for each
user currently accessing the DBEnvironment. Table 8-41 System.User
Column Name
|
Type
|
Length
| Description |
---|
USERID
|
CHAR
|
20
|
DBEUserID
|
CID
|
INTEGER
|
4
|
Unique connection identifier
|
SID
|
INTEGER
|
4
|
Session identifier. If the same USERID has multiple connections
to the same DBEnvironment from the same application (including
ISQL), all connections have the same SID.
If the user has multiple connections to the same DBEnvironment
from separate applications, each application (or ISQL session)
will have a different SID.
For more information about multiple DBEnvironment connections,
see the section "Using Multiple Connections and Transactions
with Timeouts" in the "Using ALLBASE/SQL" chapter of the ALLBASE/SQL Reference Manual.
|
Example |  |
select * FROM System.User;
--------------------+-----------+-----------
USERID |CID |SID
--------------------+-----------+-----------
JOHN@BROCK | 108| 108
---------------------------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|