17.10 - getBasePrecision() - 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 precision for the base type of the UDT or complex type. This value corresponds to the precision for time or timestamp types; for example TIME(4) or TIMESTAMP(6), otherwise it is set to zero.

The method returns a constant of type int that contains the precision value.

The method throws SQLException if an error occurs while attempting to access the precision value. A database specific code “9744 (ERRUDFJAVUDT) <UDT base precision could not be accessed>” is returned.

Syntax

int getBasePrecision()
                       throws SQLException