ASA SQL User's Guide
  Debugging Logic in the Database
    Tutorial: Getting started with the debugger
      Lesson 3: Debug a Java class

Run the method

Invoke the method from Interactive SQL

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

2. 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 Interrupt the SQL Statement button is enabled. In the debugger Source window, the yellow arrow indicates the current line.

You can now step through source code and carry out debugging activities in the debugger.