ASA SQL User's Guide
  Debugging Logic in the Database
    Working with breakpoints

Setting breakpoints

A breakpoint instructs the debugger to interrupt execution at a specified line.

When you set a breakpoint, it applies to all connections. To make a breakpoint apply to a specific connection only, set a condition on the breakpoint.

To set a breakpoint

1. With Sybase Central running the Debug task, display the code where you wish to set a breakpoint.

2. Click in the gray column on the left of the window, or click a line and press F9 to set the breakpoint. A red circle indicates each line with a breakpoint.

To set a breakpoint (Debug menu)

1. Display the Breakpoints window.

   With Sybase Central running the Debug task, choose Debug > Breakpoints.

2. In the Breakpoints window, click New Breakpoint. The New Breakpoint window is displayed.

3. Choose a Procedure name from the drop down list, and optionally enter condition and count values.

   The Condition is a SQL or Java expression that must evaluate to true for the breakpoint to interrupt execution. For example, you can set a breakpoint to apply to a connection made by a specified user, you can enter the following condition:

   CURRENT USER = 'user-name'

   The Count is a number of times the breakpoint is hit before it stops execution. A value of 0 means that the breakpoint always stops execution.

4. Click OK to set the breakpoint. The breakpoint is set on the first executable statement in the procedure.