Launching a Database Debug Session from the Run Menu

Launch a database debug session for a procedural object from the Run menu.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Find an existing procedural object.
    Procedural object Description
    Stored procedures Expand the Stored Procedures folder.
    SQL Anywhere or Sybase IQ User-defined functions Expand the User Defined Functions folder.
    Triggers Expand the Tables folder, select the table in which the trigger resides, and then expand the Triggers folder.
    SQL Anywhere or Sybase IQ events Expand the Events folder.
  3. Select Run > Open Debug Dialog from the main menu.
  4. Click Debug.

    The SQL code executes, suspending execution at the first breakpoint.

  5. Click Yes to switch to the Database Debug perspective.

    The Debug perspective appears with the SQL code in an editor window, displaying any breakpoints.

Related tasks
Launching a Database Debug Session from the Database Development Perspective
Launching a Database Debug Session from an Editor
Using Visual SQL

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