0 - 3 of 3 tags for java user defined function

Teradata 13.0 supports Table Java User Defined Functions (JUDF). A Table Java User Defined Function returns a table of data a row at a time in a loop to the caller of the function. This article will show you how to use the Teradata Plug-in for Eclipse to quickly create a Table Java User Defined Function.

A Teradata Database Java User Defined Function (JUDF) is a program that operates on data stored in relational tables. UDFs allow users to add their own extensions to the Teradata SQL language. JUDFs are implemented as external functions. This means the source is compiled externally to the DBS and kept in Java Archive (JAR) files. These JAR files are installed into the database using stored procedures in the SQLJ database. Once a JAR file is installed a JUDF can be defined to use a Java class and method within the JAR file. The JUDF is executed via a protected mode server separate from the database process. Parameters passed from the DBS are converted to their Java form and the Java return type from the JUDF  is converted back to its DBS form.