Re: [U2] Locks, releases and STATU() (oh my)

Richard Sammartino Thu, 14 Apr 2005 09:26:14 -0700

Susan, Try LIST.READU. This will list the readu locks. LIST.LOCKS lists the semaphore locks. The result from the STATUS() should tell you who has the record locked. Translating that into an actual usr can be tricky as this may be the process id (?). You should see the results from STATUS() in the results from LIST.READU.

Rich Sammartino

At 11:32 AM 4/14/2005 -0400, you wrote:

Hello wizards,

I've read what I can find on the subject, but I'm not finding what I need.
As usual, anyone who knows where the info is, I would not be the least bit
offended if you just point.  Or if you know off-hand ...

(Presently grappling with Unidata):

When I hit a lock with a:
READU this FROM that,ID LOCKED locked clause ELSE whatever

LIST.LOCKS from TCL has always been worse than useless for me.  For example
at this exact moment I'm holding locks on 3 sessions, yet if I run
LIST.LOCKS on a 4th session it displays ABSOLUTELY NOTHING.

I don't see much on offer in the LOCKED clause, although the online help
suggests that STATUS() will return the user number of the lock it ran into.
Can't understand its output... I have a very short program that displays
STATUS(), opens the file and displays STATUS() then does a READU against an
item I purposefully have locked on another session and I display STATUS()  a
third time.  What do you suppose its giving me, and what can I do with it?

1 STATUS = 0     <-- beginning of program
2 STATUS = 1     <-- after the open
3 STATUS = 197613 <-- this is what it gives me after the READU against a
locked item

What I want to do is determine who/what has the lock, tell the user, I also
want to be able to carry on under my own conditions when ud 46 flag is set
which will by default allow edits to items I've locked against my own
session.  Which is too loose -- I want to check to make sure I'm in the
exact right condition to do that and I'm not sure how I can (by seeing what
is holding the lock) but ... does anyone know how to get ANY information out
of a lock?

Susan
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Richard Sammartino Systems Analyst Information Technology School District of Philadelphia 734 Schuylkill Avenue Philadelphia, PA 19146-2397 Phone: (215) 875-4734 Fax: (215) 893-4243 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Locks, releases and STATU() (oh my)

Reply via email to