TD_ACF Function Examples | Teradata Vantage - TD_ACF Examples - Teradata Vantage

Example: TD_ACF Call for Output Columns with Default Names

EXECUTE FUNCTION INTO VOLATILE ART(ACF_RESULTS)
TD_ACF(
   SERIES_SPEC(TABLE_NAME(OceanBuoy), SERIES_ID(BuoyID), ROW_AXIS(SEQUENCE(N_SeqNo)),
      PAYLOAD(FIELDS(MAGNITUDE), CONTENT(REAL))),
   FUNC_PARAMS( MAXLAGS(6), FUNC_TYPE(0), UNBIASED(0), DEMEAN(1), QSTAT(1), ALPHA(0.1))
);

TD_ACF Output

Display the RETURNS TABLE with this statement:

SELECT * FROM ACF_RESULTS

BuoyID ROW_I OUT_MAGNITUDE QSTATVAL_MAGNITUDE PVAL_MAGNITUDE CONF_OFF_MAGNITUDE CONF_LOW_MAGNITUDE CONF_HI_MAGNITUDE
----------- ----------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ----------------------
33 0 1.00000000000000E 000 0.00000000000000E 000 0.00000000000000E 000 0.00000000000000E 000 1.00000000000000E 000 1.00000000000000E 000
33 1 -1.82920791381904E-001 6.42432305659815E-001 4.22831394099169E-001 4.11213406737868E-001 -5.94134198119772E-001 2.28292615355964E-001
33 2 2.62334001926902E-001 2.05814009332348E 000 3.57339114803943E-001 4.24749816670561E-001 -1.62415814743659E-001 6.87083818597463E-001
33 3 -3.72557919734966E-001 5.13308072597631E 000 1.62307693275134E-001 4.51316462820762E-001 -8.23874382555729E-001 7.87585430857956E-002
33 4 1.34380264470074E-001 5.56647405747344E 000 2.33947855368904E-001 5.00627133532409E-001 -3.66246869062335E-001 6.35007398002483E-001
33 5 -9.71243668550373E-002 5.81345088287831E 000 3.24796282646804E-001 5.06689879071266E-001 -6.03814245926304E-001 4.09565512216229E-001
33 6 -1.66262176948171E-001 6.60957249360441E 000 3.58466156186571E-001 5.09828261003043E-001 -6.76090437951214E-001 3.43566084054872E-001

Example: TD_ACF Call for Output Columns with Specified Names

The COLUMNS clause specifies names for the output columns.

EXECUTE FUNCTION COLUMNS(OUT_MAGNITUDE AS ACF_SAL,
   QSTATVAL_MAGNITUDE AS QST_SAL, PVAL_MAGNITUDE AS PV_SAL) 
   INTO VOLATILE ART(ACF_RESULTS)
TD_ACF(
   SERIES_SPEC(TABLE_NAME(OceanBuoy), SERIES_ID(BuoyID),ROW_AXIS(SEQUENCE(N_SeqNo)),
      PAYLOAD(FIELDS(MAGNITUDE), CONTENT(REAL))),
   FUNC_PARAMS( MAXLAGS(6), FUNC_TYPE(0), UNBIASED(0), DEMEAN(1), QSTAT(1), ALPHA(0))
);

Display the RETURNS TABLE with this statement:

SELECT * FROM ACF_RESULTS;

BuoyID ROW_I ACF_SAL QST_SAL PV_SAL
----------- ----------- ---------------------- ---------------------- ----------------------
33 0 1.00000000000000E 000 0.00000000000000E 000 0.00000000000000E 000
33 1 -1.82920791381904E-001 6.42432305659815E-001 4.22831394099169E-001
33 2 2.62334001926902E-001 2.05814009332348E 000 3.57339114803943E-001
33 3 -3.72557919734966E-001 5.13308072597631E 000 1.62307693275134E-001
33 4 1.34380264470074E-001 5.56647405747344E 000 2.33947855368904E-001
33 5 -9.71243668550373E-002 5.81345088287831E 000 3.24796282646804E-001
33 6 -1.66262176948171E-001 6.60957249360441E 000 3.58466156186571E-001