ColumnDefinition Constructors - 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™

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.