Defining Functions that Use ARRAY Types | Teradata Vantage - Defining Functions that Use ARRAY Types - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
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 Database 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++.