is there a way to disable a trigger or do I just have to drop?

[sumGirl]

Howdy all. Does informix allow one to disable a trigger, essentially
leaving it in place but toggled off? Or do I need to just drop a
trigger, do whatever and then put the trigger abck when I want to
"re-enable" it?

[Richard Kofler]

look here:
http://www-306.ibm.com/software/data/informix/pubs/library/datablade/dbdk/sqls/01cr_trg.fm.html

or in the Guide to SQL: Syntax manual, which is also online available

There you will find this (and more)
...
Use the SET TRIGGERS statement to enable or disable all or some of the
triggers on a table, or all or some of the INSTEAD OF triggers on a
view.
...

dic_k
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe

[Murray Wood (IList)]

SET TRIGGERS for {tablename} {disabled|enabled}

> -----Original Message-----
> From: owner-inf...@iiug.org
> [mailto:owner-inf...@iiug.org]On Behalf Of sumGirl
> Sent: Friday, 1 October 2004 7:55 a.m.
> To: inform...@iiug.org
> Subject: is there a way to disable a trigger or do I just have to drop?
>
>
> Howdy all. Does informix allow one to disable a trigger, essentially
> leaving it in place but toggled off? Or do I need to just drop a
> trigger, do whatever and then put the trigger abck when I want to
> "re-enable" it?

sending to informix-list