ASA SQL User's Guide
Debugging Logic in the Database
Tutorial: Getting started with the debugger
Lesson 3: Debug a Java class
This section illustrates some of the ways you can step through code in the debugger.
Following the previous section, the debugger should have stopped execution of JDBCExamples.Query at the first statement in the method:
Here are some example steps you can try:
Step to the next line Choose Debug
Run to the cursor Select the following line using the mouse, and choose Debug
max_price = price;
The yellow arrow moves to the line.
Set a breakpoint and execute to it Put the cursor at the following line (line 292) and press F9 to set a breakpoint on that line:
return max_price;
A red stop sign appears in the left-hand column to mark the breakpoint. Press F5 to execute to that breakpoint.
Experiment Try different methods of stepping through the code. End with F5 to complete the execution.
The complete set of options for stepping through source code is available from the Debug menu.
When you have completed the execution, the Interactive SQL Results pane in the Results tab displays the value 24.