TD_INPUTVALIDATOR Function Example | Teradata Vantage - TD_INPUTVALIDATOR Example - 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

TD_INPUTVALIDATOR Input Table BuoyData_Mix

OceanName BuoyID TD_TIMECODE Salinity
Pacific 2 2023-04-05 12:00:00 34.9
Atlantic 1 2023-04-05 12:00:00 35.5
Pacific 2 2023-04-05 12:15:00 35.0
Atlantic 1 2023-04-05 12:15:00 3.6
Pacific 2 2023-04-05 12:30:00 35.1
Atlantic 1 2023-04-05 12:30:00 35.7
Pacific 2 2023-04-05 12:45:00 35.0
Atlantic 1 2023-04-05 12:45:00 35.8

Example: TD_INPUTVALIDATOR Call

EXECUTE FUNCTION INTO VOLATILE ART(Results_first)
TD_INPUTVALIDATOR(
   SERIES_SPEC ( TABLE_NAME(BuoyData_Mix), ROW_AXIS(TIMECODE(TD_TIMECODE)),
      SERIES_ID(OceanName, BuoyId), PAYLOAD(FIELDS(Salinity),CONTENT(REAL))
   ),
   FUNC_PARAMS(FAILURE_MODE('FUNC_FIRST'))
);