The DISABLE RULES statement turns rule checking off for the current DBEnvironment session.
The statement is for DBA use in testing the operation of rules.
Scope |
 |
ISQL or Application Programs
SQL Syntax |
 |
Description |
 |
DISABLE RULES turns rule invocation off in the DBEnvironment for the
current session or until the ENABLE RULES statement is issued.
The statement only affects the current SID (session
id). Other users are not affected.
The DISABLE RULES statement is not cumulative; issuing additional DISABLE RULES statements will have no effect, and a warning will be
issued to this effect.
Rules are not fired retroactively when the ENABLE RULES statement is issued after the DISABLE RULES statement has been issued. If a DISABLE RULES statement is issued, rules that would otherwise be applicable
will not fire. Then, when a subsequent ENABLE RULES is issued, applicable rules fire again, but only for
subsequent data manipulation statements, not for those statements
executed while rule firing was disabled.
COMMIT WORK and ROLLBACK WORK statements have no effect on whether rules are enabled
or disabled.
Authorization |
 |
You must have DBA authority.
Example |
 |
The DBA turns off rule invocation for the current session.
The DBA performs operations without rule firing.
The DBA turns on rule invocation.
Normal firing of rules resumes.