UDF Debugging in a Controlled Environment

Extensibility covers the mechanisms by which you, as the user or developer, can extend the functionality of the Teradata Database, for example with the use of User Defined Functions, or UDFs.
Teradata Employee

UDF Debugging in a Controlled Environment

Customers are currently leveraging Teradata's features such as User Defined Functions (UDFs) and External Stored Procedures (XSPs) to develop complex applications.

The aim of this set articles is to show the user how to use the Eclipse IDE to debug in a single-node, controlled, non-production environment:

  • Java or C/C++ User Defined Functions (UDFs)
  • Java or C/C++ External Stored Procedures (XSPs)

The audience for this set of articles ranges from Teradata associates within the R&D and Professional Services organizations to  Teradata Customer and Partner developers who want to debug a UDF/XSP running on their  DBS VM before installing it on a production system.

The target DBS environment is a Teradata Express (TDExpress) VM or a Teradata Virtual Machine Edition (Teradata VME) VM.

There are 2 typical UDF/XSP debugging scenarios depending on the location of the running DBS. Local Debugging means Eclipse and DBS are running on the same machine. If the DBS VM is a VMWare cloud VM, the user can use VNC or an X server application to connect to the VM to run Eclipse there. Remote Debugging means Eclipse and DBS are running on separate machines.

The discussions in this set of articles were verified using Eclipse Indigo running on Linux, and TDExpress VM. Most of the UDF/XSP examples are taken from the SQL External Programming document, which can be obtained from this Teradata Information Products link. Some JUDF / JXSP examples are taken from the articles of Teradata Plug-in for Eclipse which extends the Eclipse IDE with plug-ins that support Teradata application developers. You can access these articles from this Getting Started with Teradata Plug-in for Eclipse link.

You would need to start with the How to Set up a UDF / XSP Debugging Environment article. After that, you could go straight to any individual article depending on your area of interest.