|
|
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.
ISQL or Application Programs
DISABLE RULES
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.
You must have DBA authority.
The DBA turns off rule invocation for the current session.
DISABLE RULES
The DBA performs operations without rule firing.
.
.
.
The DBA turns on rule invocation.
ENABLE RULES
Normal firing of rules resumes.
|