Run the method

You can invoke the Query() method from Interactive SQL (DBISQL), and see its execution interrupted at the breakpoint.

StepsInvoking the method from Interactive SQL

  1. Start Interactive SQL. Connect to the sample database as used ID DBA and password sql.

    The connection appears in the debugger Connections window list.

  2. To invoke the method, enter the following command in Interactive SQL:

    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.