15.10 - TDWMRuleControl - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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

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
   )
              .
              .
              .
;
 

Input Parameter

Description

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
  • Note: The TDWM places an exclusive lock on the TDWMLock table at startup.

    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.

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