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

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)

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++.