TDWMRuleControl Function | Application Programming Reference | Teradata Vantage - 17.10 - TDWMRuleControl - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Updates the EnabledFlag of the rule and the EnabledFlag in the base state for the rule in the TDWM database.

Syntax

REPLACE PROCEDURE TDWM.TDWMRuleControl (
  IN RuleSetId   INTEGER,
  IN RuleName    TD_ANYTYPE,
  IN Operation   VARCHAR(1) CHARACTER SET LATIN,
  IN TDWMLock    VARCHAR(1) CHARACTER SET LATIN
)
  ...
;

Syntax Elements

RuleSetId
ID of the rule set in which the rule is found.
RuleName
Name of the rule specified.
Operation
Request to enable or disable the rule:
  • E = Enable the rule
  • D = Disable the rule
TDWMLock
Type of request performed on the TDWMLock table:
  • W = Wait for the TDWMLock
  • A = Abort if the TDWMLock table is locked
  • S = Perform the update without locking the TDWMLock table
The TDWM places an exclusive lock on the TDWMLock table at startup.

Usage Notes

The TDWMRuleControl procedure must be used with rules defined only with the base state as this is the only state value that the procedure changes.

Example: Using TDWMRuleControl

CALL TDWM.TDWMRuleControl(1, 'throttle1', 'D', 'W');