TD_DWT2D Syntax | Digital Signal Processing | Teradata Vantage - TD_DWT2D 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_DWT2D with a Known Wavelet

EXECUTE FUNCTION
INTO ART (a1)
TD_DWT2D
(
MATRIX_SPEC (
   TABLE_NAME (dataTable1),
   MATRIX_ID (id),
   ROW_AXIS (SEQUENCE (y)),
   COLUMN_AXIS (SEQUENCE (x)),
   PAYLOAD (
     FIELDS (v),
     CONTENT (REAL)
   )
 ),
FUNC_PARAMS (
   WAVELET ('haar')
 )
);

Example: TD_DWT2D with a Custom Filter

EXECUTE FUNCTION
INTO ART (a1)
TD_DWT2D
(
MATRIX_SPEC (
   TABLE_NAME (dataTable1),
   MATRIX_ID (id),
   ROW_AXIS (SEQUENCE (y)),
   COLUMN_AXIS (SEQUENCE (x)),
   PAYLOAD (
     FIELDS (v),
     CONTENT (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))
);