Purpose
Returns the status of each category (that is, if it is active or not).
Definition
REPLACE FUNCTION TDWM.TDWMInquire() RETURNS TABLE (RuleSetId INTEGER, Filter_category VARCHAR(10) CHARACTER SET LATIN, Throttle_category VARCHAR(10) CHARACTER SET LATIN, Workload_category VARCHAR(10) CHARACTER SET LATIN, Vent_category VARCHAR(10) CHARACTER SET LATIN ) . . . ;
Result Rows
Column Name | Description |
---|---|
RuleSetId | ID of the rule set to apply. This must be the current rule set. |
Filter_Category | Current status of the Filters rule category. The value is either Active or Inactive. |
Throttle_Category | Current status of the Throttle rule category. The value is either Active or Inactive. |
Workload_Category | Current status of the WD rule category. The value is either Active or Inactive. |
Event_Category | Current status of the Event category. The value is either Active or Inactive. |
Example: Using TDWMInquire
SELECT * FROM TABLE (TDWM.TDWMInquire()) AS t1; *** Query completed. One row found. 5 columns returned. *** Total elapsed time was 5 seconds. RuleSetId Filter_Category Throttle_Category Workload_Category Event_Category --------- --------------- ----------------- ----------------- -------------- 9060 Inactive Inactive Active Active