EXECUTE FUNCTION - 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™

Runs an analytic function within a database.

The following rules apply to EXECUTE FUNCTION:
  • The statement does not allow UPDATE, INSERT, MERGE or DELETE functions on an analytic result table (ART).
  • You can set the name and column names associated with the result set table, but all other aspects associated with the table are managed by the database software.
  • The user cannot create an index on the table.
  • Column names cannot be renamed when the output is a series or a matrix. For output series and matrices, the row index is always named ROW_I. For matrices, the column index is always named COLUMN_I.
  • The primary layer of ART can be retrieved using a SELECT statement. Other layers can only be retrieved using the TD_EXTRACT_RESULTS function.
  • EXECUTE FUNCTION INTO VOLATILE ART fails if there is a name conflict with an existing table. In that case, you need to drop the existing table or use different name for the volatile ART.
  • An EXECUTE FUNCTION statement with no INTO clause returns the rows in the series/matrix ID and row/column axis order.