Database users with sufficient permissions can debug a UDF, an external stored procedure, or a UDM within a SQL session. On one database, multiple simultaneous SQL sessions may be started for debugging, either by the same or different users.
Users can join the Teradata C/C++ UDF Debugger only to their own SQL sessions. Nothing from other sessions is visible to them, and the debugger encrypts its message traffic to deter eavesdropping. After the debugger is joined to a session, it will see every instance of the UDF that is put into execution and is able to install breakpoints and monitor the UDF execution. One debugger can join multiple named UDFs if they execute from different SQL sessions but each session can debug only one named UDF at a time.
The debugger supports only external routines written in C or C++.
- set and display breakpoints
- display variables
- watch variables or memory locations
- resume execution
- display the function call stack
- make breakpoints conditional
- display source code
- list UDFs available for debugging
- join UDFs to the debug session
- select among multiple simultaneously executing UDFs