TD_INPUTVALIDATOR Function Example | Teradata Vantage - TD_INPUTVALIDATOR Example - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2026-03-23
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

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