You can carry out many tasks with the Sybase debugger, including the following:
Debug event handlers Event handlers are an extension of SQL stored procedures. The material in this chapter about debugging stored procedures applies equally to debugging event handlers.
Browse classes and stored procedures You can browse through the source code of installed classes and SQL procedures.
Debug Java classes You can debug Java classes that are stored in the database.
Trace execution Step line by line through the code of a Java class or stored procedure running in the database. You can also look up and down the stack of functions that have been called.
Set breakpoints Run the code until you hit a breakpoint, and stop at that point in the code.
Set break conditions Breakpoints include lines of code, but you can also specify conditions when the code is to break. For example, you can stop at a line the tenth time it is executed, or only if a variable has a particular value. You can also stop whenever a particular exception is thrown in a Java application.
Inspect and modify local variables When execution is stopped at a breakpoint, you can inspect the values of local variables and alter their value.
Inspect and break on expressions When execution is stopped at a breakpoint, you can inspect the value of a wide variety of expressions.
Execute queries When execution is stopped at a breakpoint in a SQL procedure, you can execute queries. This permits you to look at intermediate results held in temporary tables, as well as checking values in base tables.
