Purpose
Returns a list of the WDs.
Definition
REPLACE FUNCTION TDWM.TDWMListWDs (EnabledOnly VARCHAR(1) CHARACTER SET LATIN ) RETURNS TABLE (RuleSetId INTEGER, EnabledFlag VARCHAR(10) CHARACTER SET LATIN, WDId INTEGER, WDName VARCHAR(128) CHARACTER SET UNICODE ) . . . ;
Input Parameter
Parameter | Description |
---|---|
EnabledOnly | Enabled workload names. The values, Y and N, return enabled WDs only.
|
Usage Notes
This table function is only supported in Constant Mode.
The TDWMListWDs function provides similar functionality to a TDWM LIST WD request. For more information about this interface, see TDWM LIST WD.
Result Rows
Column Name | Description |
---|---|
RuleSetId | Rule set in which the WD is located. |
EnabledFlag | Indicator that the WDs specified are enabled. |
WDId | WD ID. |
WDName | Name of the WD. |
Example: Using TDWMListWDs
SELECT * FROM TABLE (TDWM.TDWMListWDs('Y')) AS t1; *** Query completed. 40 rows found. 4 columns returned. *** Total elapsed time was 2 seconds. RuleSetId EnabledFlag WDId WDName ----------- ----------- ---- ------ 9889 Enabled 201 WD1 9889 Enabled 202 WD2 9889 Enabled 203 WD3 9889 Enabled 204 WD4 9889 Enabled 205 WD5 9889 Enabled 206 WD6 9889 Enabled 207 WD7 9889 Enabled 208 WD8 9889 Enabled 209 WD9 9889 Enabled 210 WD10