16.20 - Teradata C/C++ UDF Debugger Capabilities - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)

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

Debugging facilities available for UDFs include nearly everything GDB can do to debug normal programs, including:
  • set and display breakpoints
  • display variables
  • watch variables or memory locations
  • resume execution
  • display the function call stack
  • make breakpoints conditional
  • display source code
There are also commands specific to controlling UDFs, such as:
  • list UDFs available for debugging
  • join UDFs to the debug session
  • select among multiple simultaneously executing UDFs