Teradata provides Java application classes that you can use for UDF development. The following table shows some of the classes that are available.
Class | Description |
---|---|
com.teradata.fnc.Blob | For UDFs that use an SQL BLOB type parameter or return type |
com.teradata.fnc.Clob | For UDFs that use an SQL CLOB type parameter or return type |
com.teradata.fnc.DbsInfo | For UDFs that need to obtain session information related to the current execution of the UDF |
com.teradata.fnc.TraceObj | Provides methods for UDFs that write trace output into a temporary trace table defined by a CREATE GLOBAL TEMPORARY TRACE TABLE statement for debugging purposes |
com.teradata.fnc.QueryBand | Provides methods for UDFs that need to access query band information for a session, transaction, and/or profile |
com.teradata.fnc.Phase | Classes used by an aggregate function |
com.teradata.fnc.Context | |
com.teradata.fnc.Tbl | Classes used by a table function |
com.teradata.fnc.AmpInfo | |
com.teradata.fnc.NodeInfo |
For a list of all available classes and their descriptions, see Java Application Classes.