Re: Triggers

Mike Coleson wrote: > > We are considering adding more than 10 triggers to a table. The > triggers > would be used to reflect audit trail changes. > > Are there any constraints or limits with Informix Triggers? Not as such, except there are only three types of trigger. So you would probably get your triggers to call stored procedures in order to implement your audit trails. You may even be able to code a single stored procedure to handle all triggers. Good luck. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+