TDWMIListWDs Function | Application Programming Reference | Teradata Vantage - 17.05 - TDWMListWDs - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

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