17.10 - getArrayNumDimension() - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

Retrieves the number of dimensions for an Array/Varray type. This method is not applicable to any other UDT or complex types.

The method returns a constant of type int that contains the number of dimensions of this Array/Varray type.

The method throws SQLException if an error occurs while attempting to access the dimensions information. A database specific code “9744 (ERRUDFJAVUDT) < Number of dimensions for Array/Varray could not be accessed>” is returned.

Syntax

int getArrayNumDimension()
                       throws SQLException