getColDef() - 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™

Returns the definitions of the result columns that must be returned by a table function with dynamic result row specification.

This method is only valid for table functions with dynamic result row specification.

Return Value

The getColDef() method returns an array of int, where the array elements specify the data type of the result columns that the table function must return. Valid values are defined by the following constants:

    Tbl.UNDEF_DT
    Tbl.CHAR_DT
    Tbl.VARCHAR_DT
    Tbl.BYTE_DT
    Tbl.VARBYTE_DT
    Tbl.GRAPHIC_DT
    Tbl.VARGRAPHIC_DT
    Tbl.BYTEINT_DT
    Tbl.SMALLINT_DT
    Tbl.INTEGER_DT
    Tbl.REAL_DT
    Tbl.DECIMAL1_DT
    Tbl.DECIMAL2_DT
    Tbl.DECIMAL4_DT
    Tbl.DECIMAL8_DT
    Tbl.DATE_DT
    Tbl.TIME_DT
    Tbl.TIMESTAMP_DT
    Tbl.INTERVAL_YEAR_DT
    Tbl.INTERVAL_YTM_DT
    Tbl.INTERVAL_MONTH_DT
    Tbl.INTERVAL_DAY_DT
    Tbl.INTERVAL_DTH_DT
    Tbl.INTERVAL_DTM_DT
    Tbl.INTERVAL_DTS_DT
    Tbl.INTERVAL_HOUR_DT
    Tbl.INTERVAL_HTM_DT
    Tbl.INTERVAL_HTS_DT
    Tbl.INTERVAL_MINUTE_DT
    Tbl.INTERVAL_MTS_DT
    Tbl.INTERVAL_SECOND_DT
    Tbl.TIME_WTZ_DT
    Tbl.TIMESTAMP_WTZ_DT
    Tbl.BLOB_REFERENCE_DT
    Tbl.CLOB_REFERENCE_DT
    Tbl.UDT_DT
    Tbl.BIGINT_DT
    Tbl.DECIMAL16_DT
    Tbl.NUMBER_DT

For CHAR, BYTE, CHARACTER CHARACTER SET GRAPHIC, VARCHAR CHARACTER SET GRAPHIC, VARCHAR, VARBYTE, or NUMBER data types, call Tbl.getLength() to get the length of the data type.

For TIME or TIMESTAMP data types, call Tbl.getPrecision() to get the precision of the data type.

For a DECIMAL or NUMBER data types, call Tbl.getPrecision() to get the precision and Tbl.getScale() to get the scale of the data type.