Re: Suppressing Trigger Action

Posted in 1999

Sujit.Pal@BankAmerica.com — Fri, 28 May 1999 09:31:54 -0700 — source: Informix-list mailing list archive (1991-1998)

Nayan Try: SET TRIGGER trigger_name DISABLED; before the INSERT and: SET TRIGGER trigger_name ENABLED; after. HTH Sujit Nayan Jain <nayan.jain@tatainfotech.com> on 05/28/99 12:20:50 AM To: "Informix-List (E-mail)" <informix-list@iiug.org> cc: (bcc: Sujit Pal) Subject: Suppressing Trigger Action Hi all, I have a trigger on an insert in table. Is there any way that i can suppress the trigger action on INSERT. In another word, i want to insert into the table but do not want the trigger to be fired. Any way to do that ? TIA, Nayan !