At 12:01 AM 9/20/2001 +0200, Tobias Giesen wrote:

>I want to disable certain triggers to speed up some operations - after which
>the triggers need to be re-enabled.

That's a reasonable thing to want, I guess. Here's how I would
do it. Set up a table in the database that holds the desired state
of triggers. Check that table at the start of each trigger and
do (or do not) execute the trigger. Depending on the type of concurrency,
you may need a more or less complicated state table.

>I'm using MODIFY TRIGGER

That's a bad way to do it for several reasons. First, it's global to
the database. Second, it won't work if someone else has is using those
tables. Third, every time you do it, you increment the format version
number, which is a limited resource (256 versions).


Regards,

Ann
www.ibphoenix.com
We have answers.