ARRAY Type Input & Output Parameters | Data Types & Literals | Teradata Vantage - ARRAY Type Input and Output Parameters - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
tpf1598412463935.ditamap
dita:ditavalPath
tpf1598412463935.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢

You can specify the ARRAY type as parameters and return types for UDFs written in C, C++, or Java. This includes scalar and aggregate UDFs, table functions, and table operators.

You can specify the ARRAY type as IN, INOUT, and OUT parameters of stored procedures and external stored procedures written in C, C++, or Java.

You can specify the ARRAY type as parameters and return types for UDMs written in C or C++.

ARRAY FNC functions and Java classes and methods are provided to enable a UDF, UDM, or external stored procedure to access and set the values of the elements in an ARRAY, or to get information about the ARRAY type parameter. For information about these functions and methods, see Teradata Vantageā„¢ - SQL External Routine Programming, B035-1147.