getBaseTypeName() - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

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.