Example: TD_WINDOWDFFT Call with Complex Numbers
EXECUTE FUNCTION
INTO VOLATILE ART( res1 )
TD_WINDOWDFFT
(
SERIES_SPEC
(
TABLE_NAME( t1 ),
SERIES_ID( id ),
ROW_AXIS( SEQUENCE( row_i ) ),
PAYLOAD( FIELDS( v2 ),
CONTENT( REAL ) )
),
FUNC_PARAMS
(
WINDOW( SIZE( NUM( 15 ) ) ),
WINDOW( OVERLAP( 2 ) ),
WINDOW( TYPE( BOHMAN ) ),
WINDOW( IS_SYMMETRIC( 1 ) ),
WINDOW( SCALE( SPECTRUM ) ),
DFFT( ALGORITHM( SINGLETON ) ),
DFFT( ZERO_PADDING_OK( 1 ) ),
DFFT( FREQ_STYLE( K_INTEGRAL ) ),
DFFT( HUMAN_READABLE( 0 ) )
),
OUTPUT_FMT( CONTENT( COMPLEX ) )
);
TD_WINDOWDFFT Output with Complex Numbers
SELECT id, row_i, column_i, ROUND( REAL_v2, 6 ), ROUND( IMAG_v2, 6 ) FROM res1 ORDER BY 1, 3, 2;
id ROW_I COLUMN_I ROUND(REAL_v2,6) ROUND(IMAG_v2,6)
-----------------------------------------------------------------------------------------------
3 0 0 8.57139800000000E 000 0.00000000000000E 000
3 1 0 -5.86226900000000E 000 -1.26000000000000E-004
3 2 0 1.63287700000000E 000 -1.28144000000000E-001
3 3 0 -8.33180000000000E-002 4.72920000000000E-002
3 4 0 1.09017000000000E-001 3.84140000000000E-002
3 5 0 -1.08702000000000E-001 3.32850000000000E-002
3 6 0 5.64700000000000E-003 -7.38230000000000E-002
3 7 0 2.10500000000000E-002 5.65500000000000E-002
3 8 0 2.10500000000000E-002 -5.65500000000000E-002
3 9 0 5.64700000000000E-003 7.38230000000000E-002
3 10 0 -1.08702000000000E-001 -3.32850000000000E-002
3 11 0 1.09017000000000E-001 -3.84140000000000E-002
3 12 0 -8.33180000000000E-002 -4.72920000000000E-002
3 13 0 1.63287700000000E 000 1.28144000000000E-001
3 14 0 -5.86226900000000E 000 1.26000000000000E-004