Debugging Logic in the Database

This appendix describes how to use the Sybase debugger to assist in developing SQL stored procedures and event handlers, as well as Java stored procedures.

• Introduction To Debugging In the Database
  You can use the debugger during the development.
• Tutorial 1: Getting Started With the Debugger
  These tutorials describe how to start the debugger, how to connect to a database, and how to debug a Java class.
• Tutorial 2: Debugging a stored procedure
  This tutorial describes a sample session for debugging a stored procedure.
• Tutorial 3: Debugging a Java Class
  In this tutorial, you call JDBCExamples.Query() from Interactive SQL (dbisql), interrupt the execution in the debugger, and trace through the source code for this method.
• Breakpoints
  Breakpoints control when the debugger interrupts execution of your source code.
• View and Edit Variable Behavior
  The debugger lets you view and edit the behavior of your variables while stepping through your code.
• Write Debugger Scripts
  The debugger allows you to write scripts in the Java programming language. A script is a Java class that extends the sybase.asa.procdebug.DebugScript class.