Teradata C/C++ UDF Debugger Capabilities | Teradata Vantage - Teradata C/C++ UDF Debugger Capabilities - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
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