Disable Trigger??

[aljubicic]

Hi All,

Could anyone help me on how to disable a trigger on a Informix Dynamic Server Database. I am writing a Visual Basic Application however I need the Application to disable an Insert and Update trigger when it writes to this table. In MS SQL 7, I can disable a trigger using "ALTER TABLE", is there anything in Informix that can do the same thing or would I need to drop it and recreate it each time??

Thanks
Anthony

 

[vpshriyan]

Hi,

You may use:

SET TRIGGERS trig_name ENABLED
SET TRIGGERS trig_name DISABLED

to put the object into on/off mode.

Regards,
Shriyan