16.20 - getBaseTypeName() - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Purpose

Retrieves the SQL type name of the elements in the array designated by this Array object. If the elements are a built-in type, it returns the database-specific type name of the elements. If the elements are a user-defined type (UDT), this method returns the fully qualified SQL type name.

Syntax

String getBaseTypeName()
                       throws SQLException

Return Value

A String that is the database-specific name for a built-in base type or the fully qualified SQL type name for a base type that is a UDT.

Exceptions

Throws SQLException if an error occurs while attempting to access the type name. A database specific code “9743 (ERRUDFJAVARRAY) <Array type name could not be retrieved>” is returned.