I have a need to access the Lock Table to find the Process ID of the process that has a particular global node Locked. The process holding the lock could be on any one of four application servers.
Having identified the Process ID, I then need to interrogate the local variables for that process, to find an application User ID.
I can then inform the current user which of their colleagues has a particular record locked, preventing them from continuing with their work...
Are these things I can do under Caché? If so, how would I do so?
In any answers, please bear in mind that I am mostly just a fusty old MUMPS programmer, from what increasingly seems like the dark ages, who did most of his coding in DSM for Open VMS!