Home Page for the TeradataForum
 

 

Library of User-Defined Functions


 

If you would like to submit a User-Defined Function (UDF), please contact the List Administrator .



Index of UDFs

stat_values
 

This is a Table UDF that converts the FieldStatistics (or IndexStatistics) byte string to a table of readable columns.

    Rommel, Geoffrey
isdate
 

Capable of handling different date formats, this UDF tests whether a character string is a valid date. It returns the date if valid, else a NULL is returned.

    Wridgway, Karl
is_integer
 

Tests whether a string is a numeric value (leading and trailing spaces are ignored).

    Calkins, Dennis    (Teradata-NCR)
nthValue
 

To extract the Nth value from a delimited list of values.

    Meunier, Robert    (Database Fusion)
stat_dt
 

Converts the first 4 bytes of a FieldStatistics or IndexStatistics column to an ordinary DATE data type.

    Rommel, Geoffrey





 
  Top Home Privacy Feedback  
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky
Copyright 2016 - All Rights Reserved
Last Modified: 28 Jun 2020