Returns the status of each category (that is, if it is active or not).
Syntax
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
)
...
;
Syntax Elements
- 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;
Result:
*** 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