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. For procedures and triggers, it must be a SQL search condition.
For example, to make a breakpoint apply to a specific connection only, set a condition on the breakpoint.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
In the left pane, double-click Procedures & Functions.
Select a procedure.
Choose Mode » Debug.
Choose Debug » Breakpoints.
Select the breakpoint you want to edit and then click Edit.
In the Condition list, click a condition. For example, to set the breakpoint so that it applies only to connections from a specific user ID, enter the following condition:
In this condition, user-name is the user ID for which the breakpoint is to be active.
Click OK and then click Close.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|