EXECUTE FUNCTION Syntax - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
EXECUTE FUNCTION [COLUMNS (result_name_label_list) 
    [into_volatile_clause | into_permanent_clause]
    AF_function_name
    (
       logical_data_type_reference_list
       [, FUNC_PARAMS (func_specific_params)]
       [, INPUT_FMT (input_format_specification)]
       [, OUTPUT_FMT (output_format_specification)]
       [, MAP (map_format_specification)]
     )

Syntax Elements

into_volatile_clause
INTO VOLATILE ART clause creates a volatile ART table and deposits the result series or result matrixes into the table.
The INTO ART clause creates a permanent ART table and deposits result series or result matrixes into the table.
logical_data_type_reference_list
FUNC_PARAMS
A collection of input parameters that are specific to the AF function. Valid parameters are:
  • MAXLAGS(INTEGER)
  • FUNCTION_TYPE( 0 | 1 )
  • UNBIASED( 0 | 1 )
  • DEMEAN( 0 | 1 )
  • QSTAT( 0 | 1 )
  • ALPHA(FLOAT)
INPUT_FMT
INPUT_FMT controls how input logical data types are handled by the function. Not available for all functions. Valid parameters are: INPUT_MODE ( { ONE2ONE | MANY2ONE | MATCH } )
OUTPUT_FMT
OUTPUT_FMT controls the number of primary series and the number of secondary series, and determines how the series are matched together. Valid parameters are:
  • CONTENT( {REAL | COMPLEX | AMPL_PHASE | AMPL_PHASE_RADIANS | AMPL_PHASE_DEGREES | MULTIVAR_REAL | MULTIVAR_COMPLEX | MULTIVAR_AMPL_PHASE | MULTIVAR_AMPL_PHASE_RADIANS |MULTIVAR_AMPL_PHASE_DEGREES } )
  • ROW_MAJOR( INTEGER )
  • INDEX_STYLE ( { FLOW_THROUGH | NUMERICAL_SEQUENCE } )
MAP