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

Deletes a specific rule in one or all existing rulesets. It also deletes all classification criteria and state limits associated with the rule or rules.

Syntax

REPLACE PROCEDURE TDWM.TDWMDeleteRule (
  IN RulesetName TD_ANYTYPE,
  IN RuleName TD_ANYTYPE
)
  ...
;

Syntax Elements

RulesetName
Name of the ruleset that contains the RuleName. Use ‘ALLRULESETS’ to delete the specified rule in all existing rulesets. Cannot be null and the length must be between 1 and 30.
RuleName
Name of the rule to be deleted. The rule can be either a system 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.