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

Reading the manual (SQL Syntax Guide) might sometimes
help.....

set triggers for <tablename> disabled

OR

set triggers <triggername> disabled