The SET PRINTRULES statement specifies whether rule names and
statement types are to be issued as messages when the rules are fired
during a DBEnvironment session.
Scope |
 |
ISQL or Application Programs
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:
The effects of this statement are not undone by a ROLLBACK WORK or
COMMIT WORK statement.
Authorization |
|
You must have DBA authority.
Example |
|
The DBA enables the issuing of messages when rules fire.
The DBA issues statements that fire rules.
INSERT INTO PurchDB.Parts VALUES (9213, 'Widget', 12.95)
Rule PurchDB.InsertParts fired on INSERT statement. (DBWARN 2021)
|
The DBA disables the issuing of messages when rules fire.
