Kbase P124187: How to determine which users are waiting on what records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2009 |
|
Status: Verified
GOAL:
4GL/ABL: How to determine which users are waiting on what records
GOAL:
How to programmatically find blocked users who are waiting on records using 4GL/ABL?
GOAL:
How to use the _Connect table to list all users that are waiting for locked records?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
When the value of the _Connect-Wait is equal to "REC" then the _Connect-Wait1 field stores the RECID of the record being waited for.
For example, the following 4GL code lists the user name (_Connect-Name), the RECIDs (_Connect-wait1) and process ids (_Connect-Pid) for all the records being waited for:
FOR EACH _Connect NO-LOCK WHERE _Connect-wait = "REC":
DISPLAY _Connect-Name _Connect-wait1 _Connect-Pid.
END.