That's what we used to use. It's a little more of a pain as you have to
parse through the output to find the correct record - but it should give you
need. It's simply list.readu output in an array.
Hth
Colin
-----Original Message-----
From: David A. Green
Sent: Tuesday, January 28, 2014 2:19 PM
To: 'U2 Users List'
Subject: Re: [U2] [UD] Who's locking a record
Can you get what you need using GETREADU?
David A. Green
(480) 201-7953
DAG Consulting
-----Original Message-----
From: Bill Haskett
Sent: Tuesday, January 28, 2014 1:18 PM
To: U2 Mail List
Subject: [U2] [UD] Who's locking a record
In UniData, if you do a READU you can find out the User ID who has the
record locked by using the STATUS() function; this returns the 'UID'
value. Here's a list of users:
3 Dev (0)-> lu
Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total
( 24 + 1 ) / 25 1 0 0 0 1
UDTNO USRNBR UID USRNAME USRTYPE TTY IP-ADDRESS TIME DATE
1 2488 197612 AsiAdmin phantom pts/1 Console 10:42:32 Jan 15 2014
2 3920 197610 JohnSmith udt pts/2 192.168.1.52 08:15:33 Jan
28 2014
3 180 197608 udcsuser udcs pts/3 udcs 09:22:57 Jan
28 2014
4 3840 197608 udcsuser udcs pts/4 udcs 09:23:08 Jan 28 2014
Now, if John Smith goes to read and lock a record that is locked by port#3,
how can I figure out which port# actually has the record locked, since the
UniData GETUSER() function only returns the UID, and that user, because it
is a UniObjects user, is connected on more than one port#?
I have a file managed at login that keeps track of the PORT#s and the
associated users assigned by our application. I want our logging to report
that a record lock by user so-and-so on port {n} is already in place.
Thanks.
Bill
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
