Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

Dynamically Disable Triggers

When a table contains a trigger, it can be desirable to avoid firing that trigger when performing administrative tasks such as bulk updates. This modification adds the possibility to disable triggers for the current session by calling:

SET TRIGGER OFF

Trigger executions can be reestablished by

SET TRIGGER ON

The user executing these commands needs to have resource permissions on the database.

TOCIndex