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

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

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.

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

Usage Notes

The elements of the returned array specify the data types 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.