You can invoke the Query() method from Interactive SQL (DBISQL), and see its execution interrupted at the breakpoint.
Invoking the method from Interactive SQL
Start Interactive SQL. Connect to the sample
database as used ID DBA
and password SQL
.
The connection appears in the debugger Connections window list.
Enter the following command in Interactive SQL to invoke the method:
SELECT JDBCExamples.Query()
The query does not complete. Instead, execution is stopped in the debugger at the breakpoint. In Interactive SQL, the Stop button is active. In the debugger Source window, the red arrow indicates the current line.
You can now step through source code and carry out debugging activities in the debugger.