Accessing the Value of a Distinct UDT | Teradata Vantage - Accessing the Value of a Distinct UDT - Advanced SQL Engine - Teradata Database

To access the value of a distinct UDT, follow these steps.

For detailed information on FNC_GetDistinctValue and FNC_GetDistinctInputLob, see C Library Functions.

Here is a code excerpt that shows how to access the value of a distinct type that represents a FLOAT:

void meters_t_toInches( UDT_HANDLE    *metersUdt,
                        FLOAT         *result,
                        char           sqlstate[6])
{
    FLOAT value;
    int length;
    /* Get the value of metersUdt. */
    FNC_GetDistinctValue(*metersUdt, &value, SIZEOF_FLOAT, &length);

    ...
}