Re: Database Triggers

Posted in 1998

Glyn_Balmer_at_ERITH3@smtpgwy.supertension.com — Wed, 08 Apr 98 12:32:10 GMT — source: Informix-list mailing list archive (1991-1998)

> John Bedford wrote :- > Hi, > I'm currently doing a project on Active Database Systems and I am > interested to know if anyone > actually implements triggers within their database systems and what > they find them most useful for?. I'm also interested to know of any > problems encountered with using triggers. > Any feedback would be very grateful, We currently use database triggers to enforce business rules and ensure required actions are carried out automatically - e.g. if a certain transaction is carried out, ensure the data is exported to an external (unfortunately non Informix, but that's another story...) database. We are relatively new to the world of database triggers and stored procedures as we are only at Informix-OnLine 5.01. Looking forward to moving imminently to 7.2x ODS though ! So far we have encountered few problems using triggers, mainly typos. Regards Glyn Balmer I.T. Consultant BICC Cables Limited Erith Kent UK