Re: [U2] [UD] Who's locking a record

Thanks Colin & David.  That's what I did; what a dance though!

I wonder why anyone would want STATUS() to return a value that doesn't 
give us the means to resolve the problem (as in what terminal, or what 
UO program was locking the record)? PORT.STATUS is of no value in a web 
environment because it's too slow and doesn't return a call stack on a 
UO process.

It's be really nice if we could get any information about a port/process 
simply by querying some object, instead of having to remember some 
esoteric function whose data we need to parse through.  Kind of like UD 
not telling us which darned dbms account a user is logged into!

Thanks again.

Bill
Untitled Page


------------------------------------------------------------------------
----- Original Message -----
*From:* [email protected]
*To:* 'U2 Users List' <[email protected]>
*Date:* 1/28/2014 3:49 PM
*Subject:* Re: [U2] [UD] Who's locking a record
> 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
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users