16.20 - ColumnDefinition Constructors - 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)

ColumnDefinition

public  ColumnDefinition(java.lang.String  Name,
                        int  typeval)

where:

Parameter Name Description
Name The name of the output column.
typeval The java.sql.Type of the column.

The constructor for the class requires a column name and java.sql.Types. After the class is instantiated, the characteristics of the type can be set using the methods setPrecision, setScale, setDisplayLength, etc. Calling these methods for types that do not support the specific method results in an exception.

ColumnDefinition

public  ColumnDefinition(java.lang.String  Name,
                        com.teradata.fnc.TeradataType  Type)

where:

Parameter Name Description
Name The name of the output column.
Type The com.teradata.fnc.TeradataType of the column.

The constructor for the class requires a column name and com.teradata.fnc.TeradataType. Once the class is instantiated, the characteristics of the type can be set using the methods setPrecision, setScale, setLength, etc. Calling these methods for types that do not support the specific method results in an exception. The com.teradata.fnc.TeradataType permits access to Teradata specific types.