TD_IDWT Examples | Digital Signal Processing | Teradata Vantage - TD_IDWT Examples - 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
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

Example: TD_IDWT with a Known Wavelet

EXECUTE FUNCTION
INTO ART (tmpTable)
TD_IDWT
(
  SERIES_SPEC (
    TABLE_NAME (dataTable1),
    SERIES_ID (id),
    ROW_AXIS (SEQUENCE (rowi)),
    PAYLOAD (
      FIELDS (approx, detail),
      CONTENT (MULTIVAR_REAL)
    )
  ),
FUNC_PARAMS (
  WAVELET ('haar')
)
);

Example: TD_IDWT with a Custom Filter

EXECUTE FUNCTION
INTO ART (tmpTable)
TD_IDWT
(
  SERIES_SPEC (
    TABLE_NAME (dataTable1),
    SERIES_ID (id),
    ROW_AXIS (SEQUENCE (rowi)),
    PAYLOAD (
    FIELDS (approx, detail),
    CONTENT (MULTIVAR_REAL)
    )
  ),
  SERIES_SPEC (
    TABLE_NAME (filterTable),
    SERIES_ID (id),
    ROW_AXIS (SEQUENCE (seq)),
    PAYLOAD (
    FIELDS (lo, hi),
    CONTENT (MULTIVAR_REAL)
    )
   )
WHERE id = 1,
INPUT_FMT (INPUT_MODE (MANY2ONE))
);