TDWMActiveWDs Syntax - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
REPLACE FUNCTION TDWMActiveWDs (
) RETURNS TABLE (
    WDId INTEGER,
    WDName VARCHAR(30) CHARACTER SET UNICODE,
    Status VARCHAR(8) CHARACTER SET LATIN,
    SLG INTEGER,
    PGID INTEGER,
    AGID INTEGER,
    LogMode VARCHAR(8) CHARACTER SET LATIN,
    CurrOpEnv INTEGER,
    ActualOpEnv INTEGER
  )
LANGUAGE C
NO SQL
NO EXTERNAL DATA
PARAMETER STYLE SQL 
NOT DETERMINISTIC 
CALLED ON NULL INPUT 
EXTERNAL NAME 'SL!api'';

Syntax Elements

WDId
The WD number.
WDName
The WD name.
Status
Enabled status.
SLG
Service level goal.
PGID
Performance group number assigned to the WD.
AGID
Allocation group number assigned to the WD.
LogMode
Type of logging.
CurrOpEnv
Current operating environment.
ActualOpEnv
Active operating environment.