Java User Defined Function Wizard - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
poj1484765174891.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
Product Category
Teradata Tools and Utilities

The Java User Defined Function wizard enables you to create Java user-defined function objects in the Teradata Database. To launch the wizard from the Data Source Explorer, right-click a User-Defined Functions node and select Teradata > Create Java User Defined Function. For information about this option, see Create Java User Defined Function.

The return types currently supported for the Java User Defined Function wizard are:
Return Type Description
scalar Accepts input using its argument list and returns a single result value.
table Returns a table of data, one row at a time, in a loop to the caller of the function.
aggregate Produces a summary result.
You must be running Teradata version 13.0 or higher for support of Java user-defined functions.

You can edit and manage the Java source code, JAR file, build file, and other components using the Java User Defined Multi-Page Editor.

For more information about Java user-defined functions, refer to the Teradata online publication SQL External Routine Programming, B035-1147.