15.10 - TDWMListWDs - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Returns a list of the WDs.

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
    )
             .
             .
             .
;
 

Parameter

Description

EnabledOnly

Enabled workload names.

Note: The values, Y and N, return enabled WDs only.

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” on page 356.

 

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.

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