Re: Audit Trails for Table Data Update

Posted in 1998

Art S. Kagel — Wed, 02 Sep 1998 13:47:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Samuel Tan wrote: > > Hi, > > I've read from an Informix reference book saying that Trigger can be used to > track modifications to a table. There is an example showing how to track > the INSERT on a table: [SNIP] > I'm using Informix Online 5.04 and the above trigger works. How can I > modify the above trigger so that I can track the UPDATE of a specific field > ONLY? Thank you! CREATE TRIGGER cctl_tran_updUPDATE OF ct_amt ON cctl_tran REFERENCING NEW ...... Art S. Kagel