Stored Procedure Debugger

SPL Debugger is the interactive debugger for IBM Informix stored procedures and triggers and provides powerful capabilities usually found only in high level programming languages. It enables you to execute stored procedures and triggers line-by-line, to step into nested procedures or fired triggers, to set breakpoints, to watch and to modify values of procedures' variables and calling arguments, break infinite loops, etc. SPL Debugger can be invoked from any client application or development tool, such as Visual Basic, PowerBuilder, C++, Informix-4GL, etc. Remote debugging gives you ability to execute calling application from one workstation on the network, while SPL Debugger runs on another. Simultaneous debugging sessions can be initiated from any workstation on the network. Another important feature of SPL Debugger is it's ability to "hook" into stored procedure or trigger that is already executing on the server, enabling you to identify the cause of infinite loop or to pinpoint the slowest portion of the code.

SPL Debugger supports watching and editing all types of variables including UDT, OPAQUE and COLLECTION datatypes.

Typical use of SPL Debugger

You can verify that a particular stored procedure or trigger was actually executed as a part of application logic and that correct set of parameters was passed.
You can analyze execution logic of complex SPL code, by executing it line-by-line and monitoring values of variables.
You can interactively edit values of variables or tables data to force correct execution of the logic when the logical error is found during debugging session, without the need to interrupt the debugging process.
You can verify that a stored procedure operates with the correct data, by examining values in data tables and views that the procedure?s logic depends on, when execution has been paused on a breakpoint.
You can break an infinite loop during execution of a stored procedure and proceed with its execution in a step mode, to analyze conditions that lead to the occurrence of this loop.

Note

SPL Debugger add-on module runs only under Windows platforms.

To invoke the debugger use Tools -> Stored Procedure Debugger -> Open top-level menu.

For detailed help on SPL Debugger, please use DebuggerOnlineHelp.html located in <ServerStudioJE>/modules/spldebug subdirectory.