triggers

Currently our application is doing all of the auditing but not consistent. I suggested that we use triggers on all our tables that need to be audited. Basically we audit every column in our database. I need some a really good book on how to write informix triggers. one way: The way i thought about doing this is by creating an update trigger and passing every columns old and new data to a stored procedure and in the stored procedure do the if old <> new insert that information into my audit table. since i would be processing every column every time the row is changed this seems to stress the database (i have not tried this yet). is there a way to write these triggers and have the trigger call the stored procedure only for changed columns. and can we get the name of the column that is changed passed to the stored procedure? And is there a good book on informix triggers? Help any method of auditing every column in our database would be greatly needed. Thank you in advance. dave -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own