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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » The SQL Anywhere debugger » Variables

 

Viewing variable values

View variable values in Sybase Central.

Prérequis

You must have the SA_DEBUG system role.

Additionally, you must have the EXECUTE ANY PROCEDURE system privilege or EXECUTE privilege on the procedure.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Click Mode » Debug.

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

  4. In the left pane, double-click Procedures & Functions and select a procedure.

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

    A cursor appears in the line where you clicked.

  6. Press F9.

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

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

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

  9. Click the Local tab.

Résultat

The variables, along with their values, are displayed.