Does anyone know if it is possible to get the duration that a record have been locked for via a program? I know it is possible to get a transaction duration using virtual system table _trans. But this does not help me because share-locks don't generate a transaction.
Our software supplier has some screens that have read lock and exclusive locks. Sometimes the user forgets to log out at night and it can cause overnight jobs to fail due to locking.
What I would like to do is is to create a utility program that does the below pseudocode before running the overnight utility:
Does anyone know if this is posible.
Our software supplier has some screens that have read lock and exclusive locks. Sometimes the user forgets to log out at night and it can cause overnight jobs to fail due to locking.
What I would like to do is is to create a utility program that does the below pseudocode before running the overnight utility:
Code:
FOR EACH _locks NO-LOCK:
if the lock-type is share-lock or exclusive-lock then
check the lock duration
if the lock duration is > 5 minutes then
disconnect the user.
end.
end
END.