HUPDATE record format
I am trying to decode HUPDATE records. I have indentified a transaction which changes a value in a database. I am now trying to decode the HUPDATE record so that I can determine exactly which columns within the record are updated. We have a problem in that one column in a record is being altered but we can't understand exactly why. The HUPDATE record in the logical log shows that 5 pieces of the record are being updated and I am interested to know what pieces these are. And to make my life even more exciting the value that is being changed is a floating point number. Somedays I wonder what I have done to have such an intersting challenge. Malcolm Weallans (IIUG Founder)
Just find the starting point of the floating point number in the data area of the log record via syscolumns.coltype and then map it to the dec_t structure -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MALCOLM WEALLANS Sent: Thursday, January 13, 2011 9:01 AM To: ids@iiug.org Subject: HUPDATE record format [22404] I am trying to decode HUPDATE records. I have indentified a transaction which changes a value in a database. I am now trying to decode the HUPDATE record so that I can determine exactly which columns within the record are updated. We have a problem in that one column in a record is being altered but we can't understand exactly why. The HUPDATE record in the logical log shows that 5 pieces of the record are being updated and I am interested to know what pieces these are. And to make my life even more exciting the value that is being changed is a floating point number. Somedays I wonder what I have done to have such an intersting challenge. Malcolm Weallans (IIUG Founder) **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. _____ avast! Antivirus <http://www.avast.com>; : Outbound message clean. Virus Database (VPS): 110113-0, 01/13/2011 Tested on: 1/13/2011 9:04:53 AM avast! - copyright (c) 1988-2011 ALWIL Software.
Hi Malcolm We might be able to help, see www.lintel.co.uk/infotrace. If this is overkill then contact me directly and we'll see what we can do to help. Regards David Linthwaite Lintel Software Consultancy Ltd IBM Business Partner (www.lintel.co.uk) Tel.: 01244 357250 Fax.: 01244 357248 mailto:dlinthwaite@lintel.co.uk -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MALCOLM WEALLANS Sent: 13 January 2011 15:01 To: ids@iiug.org Subject: HUPDATE record format [22404] I am trying to decode HUPDATE records. I have indentified a transaction which changes a value in a database. I am now trying to decode the HUPDATE record so that I can determine exactly which columns within the record are updated. We have a problem in that one column in a record is being altered but we can't understand exactly why. The HUPDATE record in the logical log shows that 5 pieces of the record are being updated and I am interested to know what pieces these are. And to make my life even more exciting the value that is being changed is a floating point number. Somedays I wonder what I have done to have such an intersting challenge. Malcolm Weallans (IIUG Founder) **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.