Database Debug Views

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 also go to the source file for a breakpoint.

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.

Outline

A tree view of the SQL statement or procedural definition you are editing. Clicking on part of a statement in Outline highlights the entire statement in the SQL editor.

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 Table Data Editor. Referenced Tables view opens during procedural object debugging with execution suspended.

SQL Results

A display of SQL results. In SQL Results you can view the result sets, history results, run status, and database server messages. You can also save or export result sets or results history into different file formats.

Variables

A list of local variables used in the expressions that the debugger has evaluated. You can track and edit variables using this view.

Database Explorer

A tree view of database connection profiles and utilities. You can use Database Explorer to view and edit database resources, and execute and debug procedural objects. You can also create a database service directly from this view.

Multiple databases are grouped under each Adaptive Server Enterprise server.

ASA Trigger Rows

A list of rows that show changes that result when the trigger executes, generated when debugging an ASA trigger.

External Clients

An interface that is used to connect to an external database client session, for example, the isql command tool. 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.

SQL Execution Plan

A display of the execution plan of a selected SQL statement, useful in tuning performance.