Kbase P100144: How to know how many local and remote users are connected using the _connect VST?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/3/2008 |
|
Status: Verified
GOAL:
How to know how many local and remote users are connected using the _connect VST?
GOAL:
Sample 4GL code that delivers the number of user connections.
GOAL:
Counting connections using VST.
GOAL:
ABL Sample program to display how many user connections a DB has.
FIX:
/* This program uses the VST _connect table that contains DB connection information */
DEFINE VAR N AS INTEGER INITIAL 0 NO-UNDO.
FOR EACH _connect WHERE _connect-type = "SELF" OR _connect-type= "REMC" NO-LOCK :
DISPLAY _connect-usr _connect-name _connect-device _connect-type.
N=N + 1.
END.
DISPLAY "Total # of connections: " N.