Is there PROGRESS dictionary table showing business table being locked now? - Forum - Progress User Groups - Progress Community

Is there PROGRESS dictionary table showing business table being locked now?

 Forum

Is there PROGRESS dictionary table showing business table being locked now?

This question is not answered

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
  • 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