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