ART_SPEC Element Examples | Teradata Vantage - ART_SPEC Examples - Teradata Vantage

Example: TD_ARIMAVALIDATE SQL Call

This function creates the primary results set (layer).

EXECUTE FUNCTION INTO VOLATILE ART(ARMA_VAL_MLE)
TD_ARIMAVALIDATE(
    ART_SPEC(TABLE_NAME(arima_val)),
    FUNC_PARAMS(FIT_METRICS(1),RESIDUALS(1))
);

TD_ARIMAVALIDATE Output

Example: TD_EXTRACT_RESULTS Call

EXECUTE FUNCTION INTO ART(multivar_art_res)
TD_EXTRACT_RESULTS(
    ART_SPEC(
        TABLE_NAME(arima_val),
        LAYER(ARTFITRESIDUALS)
    )
);

TD_EXTRACT_RESULTS Output