HP 3000 Manuals HP 3000 Manuals
SET PRINTRULES
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:
INSERT
UPDATE
DELETE
* 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.
SET PRINTRULES ON
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.
SET PRINTRULES OFF