16.20 - One-Dimensional ARRAY Options - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
array_type_name
The name of the one-dimensional ARRAY type to be created.
For information about naming database objects, see Teradata Vantage™ SQL Fundamentals, B035-1141.
If the UDF library for your database contains any objects with multibyte characters in their name, you cannot use a single-byte session character set to create a new UDF, UDT, method, or Java stored procedure object even if the new object name contains only single-byte characters. Otherwise, the system returns an error to the requestor. Instead, use a multibyte session character set.
SYSUDTLIB
The optional name of the containing database for array_type name.
The only valid database name is SYSUDTLIB.
data type
The data type on which the one-dimensional ARRAY type is based.
The element types of an array must be chosen from an existing Teradata Database data type categories, including Distinct UDTs, Structured UDTs, and Period data types.
You can specify any Teradata Database predefined data types except for:
  • BLOB
  • CLOB
  • Distinct and structured LOB-based UDT
  • Geospatial
  • One-dimensional ARRAY types
  • Multidimensional ARRAY types
  • JSON
  • XML and XMLTYPE
  • DATASET
You cannot specify a character server data set of KANJI1. Otherwise, the system returns an error to the requestor.
For a description of the predefined data types, see Teradata Vantage™ Data Types and Literals, B035-1143.
ARRAY
The one-dimensional ARRAY type is to be created using Teradata syntax.
number_of_elements
The number of elements in the one-dimensional ARRAY type being created. This must be an unsigned INTEGER value.
A one-dimensional ARRAY type can have a maximum size of 64,256 bytes.
The maximum size of the auto-generated transform string for the ARRAY is 64,256 bytes. The size of an auto-generated transform string for an ARRAY is limited to the maximum size of a DBS VARCHAR type. The overall limit on the number of elements is dependent on the size of the elements and the size of the transform. For details on how the size of the transform is calculated, see “Transform Input/Output Strings for ARRAY/VARRAY UDTs” in Teradata Vantage™ Data Types and Literals, B035-1143.
DEFAULT NULL
Initialize all of the elements of array_type_name to null when the type is constructed.