EXECUTE FUNCTION Syntax Elements - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

Syntax Elements

COLUMNS
The output columns of the response wavelets or ART (analytic result table) created by the analytic function. Most columns can be renamed, however the output series row index is always named ROW_I. Matrix row and column are always named ROW_I and COLUMN_I, respectively. The format is as follows:
COLUMNS ( original-name1 AS new-name1 [ , original-name2 AS new-name2 ... ] )
INTO VOLATILE ART
The INTO VOLATILE ART clause creates a non-permanent (volatile) ART and places the result series or result matrices in the table.
INTO ART
The INTO ART clause creates a permanent ART and puts result series or result matrices in the table.
analytic-function-name
The analytic function to run.
logical_data_type_reference_list
The type data and specifications for the analytic function, such as series, matrix or ART.
FUNC_PARAMS
The input parameters that are specific to the analytic function.
INPUT_FMT
INPUT_FMT controls how input logical data types are handled by the function. Not available for all functions. Valid parameters are ONE2ONE, MANY2ONE, and MATCH.
[Optional] OUTPUT_FMT
OUTPUT_FMT controls the number of primary series and the number of secondary series, and determines how the series are matched together. It is not available for all functions.
MAP
The name of a Teradata sparse map to apply to an output ART table or output spool file created during the query.