DISABLE RULES

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

DISABLE RULES

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. 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 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.

   DISABLE RULES

The DBA performs operations without rule firing.

. . .

The DBA turns on rule invocation.

   ENABLE RULES

Normal firing of rules resumes.

DISABLE RULES

Technical documentation

» Table of Contents

» Index

Scope

SQL Syntax

Description

Authorization

Example