TDWMListWDs - Teradata Database - Teradata Vantage NewSQL Engine

Application Programming Reference

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
vwf1492987142269.ditamap
dita:ditavalPath
changebar_rev_16_20_exclude_audience_ie.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantage™

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