TD_EXTRACT_RESULTS Function Examples | Teradata Vantage - TD_EXTRACT_RESULTS Examples - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

TD_EXTRACT_RESULTS Call to Display Secondary Layer

EXECUTE FUNCTION
TD_EXTRACT_RESULTS(
   ART_SPEC( TABLE_NAME(LR_age_height_art), LAYER(ARTFITMETADATA)
   )
);

TD_EXTRACT_RESULTS Output for Secondary Layer

BuoyID 33
ROW_I 0
STD_ERROR2 2.55963830486807E-001
STD_ERROR_DF 10
MULTIPLE_R_SQUARED 9.88763937143289E-001
ADJUSTED_R_SQUARED 9.87640330857618E-001
FSTATISTIC 8.79991461201834E 002
EXPLAINED_DF 1
UNEXPLAINED_DF 10
PROB_VALUE 4.42807136634978E-011

TD_EXTRACT_RESULTS Call to Display Tertiary Layer

EXECUTE FUNCTION
TD_EXTRACT_RESULTS( 
   ART_SPEC( TABLE_NAME(LR_age_height_art), LAYER(ARTFITRESIDUALS) 
   )
);

TD_EXTRACT_RESULTS Output for Tertiary Layer

BuoyID ROW_I X1 ACTUAL_VALUE CALC_VALUE RESIDUAL
----------- ----------- ---------------------- ---------------------- ---------------------- ----------------------
33 0 1.80000000000000E 001 7.61000000000000E 001 7.63576923076923E 001 -2.57692307692352E-001
33 1 1.90000000000000E 001 7.70000000000000E 001 7.69926573426574E 001 7.34265734261896E-003
33 2 2.00000000000000E 001 7.81000000000000E 001 7.76276223776224E 001 4.72377622377593E-001
33 3 2.10000000000000E 001 7.82000000000000E 001 7.82625874125874E 001 -6.25874125874333E-002
33 4 2.20000000000000E 001 7.88000000000000E 001 7.88975524475525E 001 -9.75524475524736E-002
33 5 2.30000000000000E 001 7.97000000000000E 001 7.95325174825175E 001 1.67482517482497E-001
33 6 2.40000000000000E 001 7.99000000000000E 001 8.01674825174825E 001 -2.67482517482534E-001
33 7 2.50000000000000E 001 8.11000000000000E 001 8.08024475524476E 001 2.97552447552420E-001
33 8 2.60000000000000E 001 8.12000000000000E 001 8.14374125874126E 001 -2.37412587412607E-001
33 9 2.70000000000000E 001 8.18000000000000E 001 8.20723776223776E 001 -2.72377622377647E-001
33 10 2.80000000000000E 001 8.28000000000000E 001 8.27073426573427E 001 9.26573426573185E-002
33 11 2.90000000000000E 001 8.35000000000000E 001 8.33423076923077E 001 1.57692307692287E-001