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

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

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