Debugging an External Stored Procedure | Teradata Vantage - 17.10 - Debugging an External Stored Procedure - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)
When debugging an external stored procedure, be sure your tests include the following:
  • Limit checks on input values
  • Limit checks on return values
  • Proper handling of NULLs
  • Division by zero
  • All memory acquired by malloc is freed
  • All open operating system handles are released/closed

The Teradata C/C++ UDF Debugger allows external stored procedures to be debugged within the database on a development or test system. The debugger only supports C and C++ external stored procedures. For more information on the Teradata C/C++ UDF Debugger, see C/C++ Command-line Debugging for UDFs.

For other external stored procedures, debugging is limited after they are installed in the database. You can use other debugging tools to verify their functionality, or run them on a standalone virtual machine and debug the UDF server processes that executes them.