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 . 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.