GENSERIES_SPEC Element Example | Teradata Vantage - GENSERIES_SPEC Example - Teradata Vantage

Example: Using GENSERIES_SPEC with TD_GENSERIES4FORMULA

EXECUTE FUNCTION INTO VOLATILE ART(mytab)
TD_GENSERIES4FORMULA(
    GENSERIES_SPEC(
       INSTANCE_NAMES('{"BuoyID": 3 }'),
       DT(INTEGER),
       GEN_PAYLOAD(0,1,5)
    ),
    FUNC_PARAMS(FORMULA('Y = 3.0 + 8.0*X1')), 
    OUTPUT_FMT(INDEX_STYLE(NUMERICAL_SEQUENCE))
);

TD_GENSERIES4FORMULA Output