TDWMManageRule | Application Programming Reference | Vantage - 17.10 - TDWMManageRule - 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)

Enables or disables a specific rule or rules. If the operation is to enable a rule, some validations are performed (for example, qualification criteria, default state limit) to reduce the risk of enabling an incomplete rule. If a rule fails any validation, the rule remains disabled.

Syntax

REPLACE PROCEDURE TDWM.TDWMManageRule (
  IN RulesetName TD_ANYTYPE,
  IN RuleName TD_ANYTYPE,
  IN Operation CHAR(1) CHARACTER SET LATIN
)
  ...
;

Syntax Elements

RulesetName
Name of the ruleset that contains the RuleName. Use ‘ALLRULESETS’ to enable the specified rule in all existing rulesets. Cannot be null and its length must be between 1 and 30.
RuleName
Name of the rule to be managed. A combination of RulesetName and RuleName uniquely identifies a specific throttle or an arrival rate meter. The specified name must be unique among all existing TASM rules: throttles, arrival rate meters, workloads, filters, and so on. Cannot be null and the length must be between 1 and 30.
Operation
  • 'E' = enable
  • 'D' = disable