16.20.16.20 - 16.20 - ARRAY Type Input and Output Parameters - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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 .