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

sumGirl wrote: > > 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? 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