TD_EXTRACT_RESULTS

The TD_EXTRACT_RESULTS utility function is used to retrieve auxiliary result sets stored within the ART table.

Options

Output Schema: Output Schema, if Volatile is true then use user login as the schema.
Output Table: Output Table
VAL Location: VAL Location
Volatile: Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

: Connection to a Teradata Database Instance
: This AF function is passed an ART table specification, ART_SPEC. Within the ART_SPEC, the only thing that has to be passed in is the TABLE_NAME and LAYER. The PAYLOAD option can be omitted since all available payload columns need to be passed in to this function.