Re: [U2] [UD] Who's locking a record
"David A. Green" <[email protected]>
| Newsgroups | gmane.comp.db.u2.general |
|---|---|
| Message-ID | <001701cf1c6e$88370080$98a50180$@com> |
Can you get what you need using GETREADU? David A. Green (480) 201-7953 DAG Consulting -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of 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