Debugging is a regular part of any software development. Event handlers can be debugged during the development process.
For information on developing event handlers, see “Developing event handlers”.
For information on using the debugger, see Appendix C, “Debugging Logic in the Database.”.
From a system command prompt, change directory to the directory holding the Sybase IQ software for your operating system.
Enter the following command to start the debugger:
dbprdbg
In the Connect login window, enter user name and password, then click OK.
In the Connections window, double click All Connections.
In the procedures window, double click the event you wish to debug. The event definition is displayed in the Source window.
In the Source window, set a breakpoint.
From Interactive SQL or another application, trigger the event handler using the TRIGGER EVENT statement.
The execution stops at the breakpoint you have set. You can now use the debugger features to trace execution, local variables, and so on.
Debugging an event handler