HPlogo ALLBASE/SQL Reference Manual: HP 9000 Computer Systems > Chapter 11 SQL Statements E - R

ENABLE RULES
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

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.



ENABLE AUDIT LOGGING
  		 


END DECLARE SECTION  
Feedback to webmaster