TD_DFFTCONV Function Example | Teradata Vantage - TD_DFFTCONV Example - Teradata Vantage

TD_DFFTCONV Call

EXECUTE FUNCTION INTO VOLATILE ART(DFFTCONV_HR_OUT)
TD_DFFTCONV(
   ART_SPEC( TABLE_NAME(DFFT_RAW_OUT)),
   FUNC_PARAMS(CONV(RAW_TO_HR), FREQ_STYLE(K_INTEGRAL) ),
   OUTPUT_FMT(CONTENT(AMPL_PHASE_RAdians))
);

TD_DFFTCONV Output

SEL TOP 18 * FROM DFFTCONV_HR_OUT ORDER BY ID,ROW_I;

ID ROW_I AMPLITUDE_MAGNITUDE PHASE_MAGNITUDE
----------- ----------- ---------------------- ----------------------
33 -4 4.00000000000000E 000 3.14159265358979E 000
33 -3 4.32956880116958E 000 -2.74889357189107E 000
33 -2 5.65685424949238E 000 -2.35619449019234E 000
33 -1 1.04525037190110E 001 -1.96349540849362E 000
33 0 3.60000000000000E 001 0.00000000000000E 000
33 1 1.04525037190110E 001 1.96349540849362E 000
33 2 5.65685424949238E 000 2.35619449019234E 000
33 3 4.32956880116958E 000 2.74889357189107E 000
33 4 4.00000000000000E 000 3.14159265358979E 000
34 -4 4.00000000000000E 000 3.14159265358979E 000
34 -3 4.32956880116958E 000 -2.74889357189107E 000
34 -2 5.65685424949238E 000 -2.35619449019234E 000
34 -1 1.04525037190110E 001 -1.96349540849362E 000
34 0 1.00000000000000E 002 0.00000000000000E 000
34 1 1.04525037190110E 001 1.96349540849362E 000
34 2 5.65685424949238E 000 2.35619449019234E 000
34 3 4.32956880116958E 000 2.74889357189107E 000
34 4 4.00000000000000E 000 3.14159265358979E 000