|
|
The ENABLE RULES statement turns rule checking on for the current
DBEnvironment session. DBAs use it to tune the DBEnvironment and test the
operation of rules.
ISQL or Application Programs
ENABLE RULES
ENABLE RULES returns the DBEnvironment session to its
default behavior of firing all applicable rules.
The statement only affects the current SID (session id). Other
users are not affected.
The ENABLE RULES statement is not cumulative; issuing
additional ENABLE 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. That is, 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 will fire
again, but only for subsequent data manipulation statements, not for
rows processed while rule firing was disabled.
COMMIT WORK and ROLLBACK WORK statements have no
effect on whether rules are enabled or disabled.
You must have DBA authority.
The DBA turns off rule invocation.
DISABLE RULES
The DBA performs operations without rule firing.
.
.
.
The DBA turns on rule invocation.
ENABLE RULES
Normal firing of rules resumes.
|