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.
In the Which User Would You Like To Debug field, type * to debug all users, or type the name of the database user you want to debug.
In the right pane, click the line where you want to insert the breakpoint.
A cursor appears in the line where you clicked.
A red circle appears to the left of the line of code.
In the Debugger Details pane, click the Local tab.
In the left pane, right-click the procedure and choose Execute From Interactive SQL. The variables, along with their values, appear on the Local tab.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|