Debugging an event handler

Debugging is a regular part of any software development. Event handlers can be debugged during the development process.

To debug an event handler (Sybase Central)

Connect to the database as a user with DBA authority.
From the Mode menu, choose Debug.
In the left pane, double-click Events.
Double-click the event you want to debug.
On the SQL tab in the right pane, press F9 to 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 set.