Re: Informix Triggers

Hi Just to clarify: Trigger-functionality was introduced in OnLine 5.01. There exists an OnLine 5.00, which does not support triggers ! I think the latest maintenance release of version 5 is 5.11.XX. Regards Klaus At 02:31 05-01-98 -0600, you wrote: }Like Jason mentioned, I thought Informix 5 did support them, however, if the }version you are using really doesn't I would suggest implementing your trigger }functionality into a function call. [In fact, I am certain version 5 does }support them, now that I think about it.] } }This may be easier said than done, as it basically requires you to call an }INSERT, DELETE, or UPDATE function in place of every insert,delete, or update }you may have in your code, but I guess it depends on how bad you think you need }it. Also, the performance costs of such a move may affect whether or not you }want to do it. If you've got a table with alot of columns in it, passing a }structure might be costly, especially if it's done in 4GL. } }If you're already running without triggers, and plan to upgrade within 6-12 }months, I'd probably take what I suspect Informix sales people would }recommend....upgrade ASAP, and implement them the same way.....OR re-evaluate }your "need" for triggers...maybe you don't need them, or maybe there is a Q&D }fix to whatever problem makes you think you need them all of a sudden. } } }Information Systems, Maroochy Shire Council wrote: } }> I am running Informix 5 with a view to upgrading to Informix 7 in 6-12 }> months. In the meantime, we have an urgent need to implement some triggers }> within our database. As Informix 5 does not support triggers, is there }> another way to achieve the same functionality as triggers. }> }> Regards, }> }> Darren Fuller. } } } }-- }- Danny Wright } }#include <stddisclaimers.h> } } } }