Use the views available in the Database Debug perspective to debug procedural objects.
The following tables describe the views used in the Database Debug perspective.
| View | Description |
|---|---|
| Breakpoints | The code line where the breakpoints are set for any type of procedural object. Use the Breakpoints view to remove, disable, and enable existing breakpoints. You can view and set breakpoints in the source file. |
| Debug | A display of the execution stack that allows you to track execution of code. You can use the Debug view toolbar to step through code, and resume, suspend, or terminate execution of a procedural object during a debug session. |
| Variables | A list of local variables used in the expressions that the debugger has evaluated. You can track and edit variables using this view. |
| View | Description |
|---|---|
| Outline | A tree view of the SQL statement or procedural definition you are debugging. |
| View | Description |
|---|---|
| ASA Trigger Rows | A list of rows that show changes that result when the trigger executes, generated when debugging a SQL Anywhere/Adaptive Server Anywhere trigger. |
| External Clients | An interface that is used to connect to an external database client session, for example, the isql utility. To debug the external database client session, use the SQL Debugger. |
| Global Variables | A read-only list of all system global variables for use when debugging ASA procedural objects. |
| Referenced Tables | A list of tables and views referenced in the object being debugged, with details of the selected table or view. You can sort or filter data in the view and edit table data using the Table Data Editor. The Referenced Tables view opens during procedural object debugging when execution is suspended. |
| View | Description |
|---|---|
| Execution Plan | A display of the execution plan of a selected SQL statement. Execution plans are used in performance tuning. |
| SQL Results | A display of SQL results. View result sets, history results, run status, and database server messages from this view. You can also save or export result sets or results history into different file formats. |
For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com