Defining Functions that Use ARRAY Types | Teradata Vantage - Defining Functions that Use ARRAY Types - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

An ARRAY data type is a named data type with a defined maximum number of elements of the same data type. An ARRAY data type can have one or more dimensions, and allows values of the same data type to be stored sequentially or in a matrix-like format. The ARRAY data type extends the number of data values of the same type that can be stored in a table row.

Teradata supports one-dimensional (1-D) and multidimensional (n-D) ARRAY data types. You can define ARRAY input and output parameters for UDFs, UDMs, and external stored procedures that are written in C or C++.