Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » The SQL Anywhere debugger » Variables


Viewing variable values

Administrators can view variable values in Sybase Central.


DBA authority.

Context and remarks


 View variable values
  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, double-click Procedures & Functions.

  3. Select a procedure.

  4. Click Mode » Debug.

  5. 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.

  6. In the right pane, click the line where you want to insert the breakpoint.

    A cursor appears in the line where you clicked.

  7. Press F9.

    A red circle appears to the left of the line of code.

  8. In the Debugger Details pane, click the Local tab.

  9. In the left pane, right-click the procedure and click Execute From Interactive SQL.

  10. Click the Local tab.


The variables, along with their values, are displayed.