TDWMIListWDs Function | Application Programming Reference | Teradata Vantage - 17.10 - TDWMListWDs - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

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.
The values, Y and N, return enabled WDs only.
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;
 *** 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