MATRIX_SPEC Element Examples | Teradata Vantage - MATRIX_SPEC 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: Using MATRIX_SPEC with TD_CONVOLVE2

EXECUTE FUNCTION INTO VOLATILE ART(ART_Res)
TD_CONVOLVE2(
    MATRIX_SPEC(
      TABLE_NAME(Convolve2ValidLeft),
      MATRIX_ID(ID),
      ROW_AXIS(SEQUENCE(ROW_I)),
      COLUMN_AXIS(SEQUENCE(COLUMN_I)),
      PAYLOAD(FIELDS(B), CONTENT(REAL))
    ),
    MATRIX_SPEC(
      TABLE_NAME(Convolve2ValidRight), MATRIX_ID(ID),
      ROW_AXIS(SEQUENCE(ROW_I)),
      COLUMN_AXIS(SEQUENCE(COLUMN_I)),
      PAYLOAD( FIELDS(A), CONTENT(REAL))
    ),
    INPUT_FMT(INPUT_MODE(MATCH))
);

Example: Using MATRIX_SPEC with TD_PLOT

EXECUTE FUNCTION INTO VOLATILE ART(tmpTable)
TD_Plot (
    MATRIX_SPEC (
        TABLE_NAME(waveletTable),
        ROW_AXIS(SEQUENCE(x)),
        COLUMN_AXIS(SEQUENCE(y)),
        MATRIX_ID(ID),
        PAYLOAD
        (
            FIELDS(c),
            CONTENT(REAL)
        )
    ),
    FUNC_PARAMS (
        PLOTS[(TYPE('wiggle'))],
        IMAGE('svg')
    )
);