Re: tracking data changes (a request for advice/information)

jgordon@ssf-sys.DHL.COM (Jim Gordon) writes: >[I wrote:] >> >> I need the ability to track any changes to a large OnLine database, to the >> table/row/column level*, without having to constantly scan all of the tables, >> and without building any special abilities into the applications doing the >> adding/deleteing/updating. >>[...] >> The most obvious solution I can think of is having transaction logging turned >> on, and monitoring the logical log. I guess my questions are: > >I can't comment on the Online Log idea but another solution would be >to wait for Online 5.01 and use the Triggers to write records to log >files after every insert/update/delete on the tables and columns you >need to monitor. Ok, but how do the triggers work conceptually? Can you give me a general example of how they are set up, and what they do? >Also you run the risks of bugs in the Trigger system. Against this >Informix have given themselves considerable extra time to get Triggers >reasonably clean. They were supposed to be in 5.0 but at release time >were not stable enough so they left them out. The sales rep says no 5.01 in sight. Does anyone out there (maybe someone from INFORMIX) have even a wild guess of when we should start looking for 5.01? Years? A few months (hope, hope)? >Cheers - Jim Thanks Jim. -Chris -- Chris Mathes, Metters Industries, Inc. UUCP: {..!}uunet!metter!chris Tel:(703)418-0323 INET: chris@metter.fmpmis.metter.com "The Tao of Programming flows far away and returns on the wind of morning."-TToP