""robertgilland"" <robert_gilland@...> schrieb im Newsbeitrag news:<co32hm+9vr5@...>...

>
>
> We want to temporarily disable all triggers on
> a specific table.
> We need to do this when we do our initial injection
> of data into a specific table.
> Is there any method for doing this.
> We do not want to drop the triggers just deactivate them
> temporarily.
>
> Regards,
>
>
> Robert.
>

Read the manual:
http://www.ibphoenix.com/downloads/60All.zip

There is a language reference (LANGREF.PDF)

ALTER TRIGGER

Changes an existing trigger.
Available in DSQL and isql.
Syntax
ALTER TRIGGER name[ACTIVE | INACTIVE][{BEFORE | AFTER} {DELETE | INSERT | UPDATE}][POSITION number][AS <trigger_body>] [terminator]

Description
ALTER TRIGGER changes the definition of an existing trigger. If any of the arguments to ALTER TRIGGER are omitted, then they default to their current values, that is the value specified by CREATE TRIGGER, or the last ALTER TRIGGER....

In your case ALTER TRIGGER TriggerName INACTIVE;

Or look here:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_sqlref

Cheers