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
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantageā„¢

An ARRAY data type is a named data type that has a defined maximum number of elements of the same specific data type. An ARRAY data type can be defined to be of one or more dimensions and permits many values of the same data type to be stored sequentially or in a matrix-like format. This 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 multi-dimensional (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++.