Is there PROGRESS dictionary table showing business table be

Posted by frank G on 28-Mar-2017 22:12

Oracle has some session table which will show tables being locked now.

Such as:

FROM ALL_OBJECTS A,
V$LOCKED_OBJECT B,
SYS.GV_$SESSION C 
WHERE ( A.OBJECT_ID = B.OBJECT_ID )
AND (B.PROCESS = C.PROCESS )

So, does PROGRESS also have these kinds of tables for USER to trace locked tables.

Thanks a lot.

All Replies

Posted by gus bjorklund on 29-Mar-2017 08:02

thare are a large number of VST’s (Virtual System Tables) that have the information you want as well as a host of other useful things.

check out the virtual system tables appendix in the database administration book in the docs

This thread is closed