Returns a list of the WDs.
Syntax
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
)
...
;
Syntax Elements
- EnabledOnly
- Enabled workload names.
- RuleSetId
- Rule set in which the WD is located.
- EnabledFlag
- Indicator that the WDs specified are enabled.
- WDId
- WD ID.
- WDName
- WD ID.
- WDName
- Name of the WD.
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.
Example: Using TDWMListWDs
SELECT * FROM TABLE (TDWM.TDWMListWDs('Y')) AS t1;
Result:
*** 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