Input Data for Table
All output examples use the following input table.
c1 c2
----------- -----------
5 6
7 8
3 4
1 2
Example: TD_CONVERTTABLEFORUAF Call for Output Matrix with Complex Data
SELECT * FROM TD_CONVERTTABLEFORUAF(ON t1 AS INPUTTABLE USING TABLETYPE('MATRIX') CONTENT('COMPLEX') ID(1)) AS T;
Output Matrix with Complex Data
MATRIX_ID ROW_ID COL_ID REAL IMAGINARY
----------- ---------------------------------------- ------ ---------------------- ----------------------
1 5192304002533739052549348008132608. 2 5.00000000000000E 000 6.00000000000000E 000
1 5192322705765788028280333678936064. 2 7.00000000000000E 000 8.00000000000000E 000
1 5192364527464112107435587333521408. 2 3.00000000000000E 000 4.00000000000000E 000
1 5192345824232063131704601662717952. 2 1.00000000000000E 000 2.00000000000000E 000
Example: TD_CONVERTTABLEFORUAF Call for Output Matrix with Amplitude and Phase Data
SELECT * FROM TD_CONVERTTABLEFORUAF(ON t1 AS INPUTTABLE USING TABLETYPE('MATRIX') CONTENT('AMPLPHASE') ID(1)) AS T;
Output Matrix with Amplitude and Phase Data
MATRIX_ID ROW_ID COL_ID AMPLITUDE PHASE
----------- ---------------------------------------- ------ ---------------------- ----------------------
1 5192304002533739052549348008132608. 2 5.00000000000000E 000 6.00000000000000E 000
1 5192322705765788028280333678936064. 2 7.00000000000000E 000 8.00000000000000E 000
1 5192364527464112107435587333521408. 2 3.00000000000000E 000 4.00000000000000E 000
1 5192345824232063131704601662717952. 2 1.00000000000000E 000 2.00000000000000E 000
Example: TD_CONVERTTABLEFORUAF Call for Output Series with Complex Data
SELECT * FROM TD_CONVERTTABLEFORUAF(ON t1 AS INPUTTABLE USING TABLETYPE leType('SERIES') Content('MULTIVARCOMPLEX') ID(1)) AS T;
Output Series with Complex Data
SERIES_ID SERIES_ROW_ID REAL_c1 IMG_c2
----------- ---------------------------------------- ---------------------- ----------------------
1 5192304002533739052549348008132608. 5.00000000000000E 000 6.00000000000000E 000
1 5192322705765788028280333678936064. 7.00000000000000E 000 8.00000000000000E 000
1 5192364527464112107435587333521408. 3.00000000000000E 000 4.00000000000000E 000
1 5192345824232063131704601662717952. 1.00000000000000E 000 2.00000000000000E 000
Example: TD_CONVERTTABLEFORUAF Call for Output Series with ADHOC Data
SELECT * FROM TD_CONVERTTABLEFORUAF(ON t1 AS INPUTTABLE USING TABLETYPE('SERIES') CONTENT('ADHOC') ID(1)) AS T;
Output Series with ADHOC Dat
SERIES_ID SERIES_ROW_ID c1 c2
----------- ---------------------------------------- ----------- -----------
1 5192304002533739052549348008132608. 5 6
1 5192322705765788028280333678936064. 7 8
1 5192364527464112107435587333521408. 3 4
1 5192345824232063131704601662717952. 1 2