tblog decode of HUPDAT type record
Posted in 1994
Topics: Logging & Checkpoints
Can anyone tell me the before and after column values of this updated row? The following segment is output from the "tblog -l" command. 402c 56 HUPDAT 3 0 4018 2000380 101 0 20 20 3 00380049 00000003 00004018 02000380 .8.I.... ..@..... 00000101 00000000 00140014 00030000 ........ ........ 00026332 43320006 00020000 1700000c ..c2C2.. ........ 00026332 43326e2f ..c2C2n/ The software in question: INFORMIX-OnLine Version 5.01.UD3 Thu Sep 23 16:52:58 PDT 1993 The table in question: { TABLE "informix".tmw_ces row size = 20 number of columns = 3 index size = 0 } create table "informix".tmw_ces ( char4 char(4), dec12 decimal(12), char8 char(8) ); The MathWorks is trying to solve the problem of how and when a table got changed by looking at past logical logs. A tech. spec. on how to decode all record types output by tblog would be nice. Thanks.