ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 413
SQL Statements E - R
ENABLE RULES
ENABLE RULES
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.
Scope
ISQL or Application Programs
SQL Syntax
ENABLE RULES
Description
• 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.
Authorization
You must have DBA authority.
Example
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.