SET PRINTRULES

Scope

SQL Syntax

  SET PRINTRULES [ON
                  OFF]

Parameters

ON

specifies that rule name and statement type should be issued as a message when the rule is fired.

OFF

specifies that rule name and statement type should not be issued as a message when the rule is fired. This is the default for all sessions.

Description

• SET PRINTRULES OFF returns the DBEnvironment session to its default behavior of not issuing messages with rule names and statement types as rules fire.

• SET PRINTRULES ON causes rule names and statement types (INSERT, DELETE, UPDATE) to be issued as messages in the current DBEnvironment session until the session completes or a SET PRINTRULES OFF statement is executed.

• SET PRINTRULES ON has no effect if rule printing is already on in the DBEnvironment.

• SET PRINTRULES OFF has no effect if rule printing is already off in the DBEnvironment.

• The statement only affects the current SID (session id). Other users are not affected.

• Rule names are printed by issuing an informative message DBWARN 2021, with the following text:

  
     Rule Owner.RuleName fired on StatementType statement.
  
  

  StatementType is one of the following:

  • INSERT

  • UPDATE

  • DELETE

• The effects of this statement are not undone by a ROLLBACK WORK or COMMIT WORK statement.

Authorization

Example

   SET PRINTRULES ON

   INSERT INTO PurchDB.Parts VALUES (9213, 'Widget', 12.95)

   Rule PurchDB.InsertParts fired on INSERT statement. (DBWARN 2021)

   SET PRINTRULES OFF