ASA SQL User's Guide
Debugging Logic in the Database
Working with breakpoints
You can add conditions to breakpoints, to instruct the debugger to interrupt execution at that breakpoint only when a certain condition or count is satisfied.
To add a condition or count to a breakpoint
Open the Breakpoints window.
For a Java class, the condition must be a Java boolean expression. For procedures and triggers, it must be a SQL search condition.
In the procedure sp_contacts, you might use the breakpoint
contact.id = contact.old_id
on the line
DELETE FROM contact WHERE contact.id = contact.old_id
In the Java method JDBCExamples.Query(), you might use the breakpoint condition
(price < 10)
on the line
if (max.price == price) or (price == 10)