You must specify a minimum of 2 dimensions for a multidimensional ARRAY type. The maximum number of dimensions you can specify is 5.
A multidimensional ARRAY type can have a maximum size of 64,256 bytes. The auto-generated transform string for the ARRAY can have a maximum size of 64,256 bytes. The size of an auto-generated transform string for the 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 Teradata Vantage™ - Data Types and Literals, B035-1143.
- SYSUDTLIB
- Optionally, the name of the containing database for array_type name.
- array_type_name
- The name of the multidimensional ARRAY type to be created.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.
- data_type
- The data type on which the multidimensional ARRAY type is based.
- lower_bound
- A signed INTEGER number that defines the lower bound for a multidimensional ARRAY type dimension. The lower boundary can be a negative number and must be less than or equal to upper_bound.
- upper_bound
- A signed INTEGER number that defines the upper bound for a multidimensional ARRAY type dimension. The upper boundary can be a negative number and must be greater than or equal to lower_bound.
- maximum_size
- The maximum size of a dimension of a type created as a multidimensional ARRAY. The current dimension of the multidimensional ARRAY can have a maximum size of 64,256 bytes.
- DEFAULT NULL
- Initialize all of the elements of array_type_name to null when the type is created.