Launching a Database Debug Session from the Database Development Perspective

Launch a database debug session from the Database Development perspective.

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	Expand the Databases folder. Expand the tree for a database and then the tree for the appropriate schema owner.
From a SQL Anywhere or Sybase IQ connection profile	Expand the tree for a database. Expand the Schemas folder and then the tree for the appropriate schema owner.

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.

Right-click the object you want to debug, and choose Debug.

Procedural object	Debug method
Stored procedures or events with parameters	Use the Configure Parameters dialog to change the values of parameters, and then click OK. The procedure executes up to the first breakpoint. Its status appears in SQL Results. Click Yes in the Confirm Perspective Switch dialog to verify switching to Database Debug perspective.
Triggers	Modify the launch configuration in the Edit Configuration and Launch page. In the Run frame, add the SQL code to fire the trigger by using the SQL button to choose an insert, update, or delete command. Select the tables whose attributes you want to modify and click Open. The Update (or Insert or Delete) Column Values pane appears. Select the column to modify, and enter the values in the Values column, using the operators as needed and click OK. Click OK and select Apply, and then choose Debug to execute the SQL code. Database Debug suspends execution at the first breakpoint. The SQL code appears in an editor window, displaying breakpoints. Detailed information on the execution appears under the Debug tab in the SQL Results view.

Procedural object

Debug method

Stored procedures or events with parameters

Use the Configure Parameters dialog to change the values of parameters, and then click OK.

The procedure executes up to the first breakpoint. Its status appears in SQL Results. Click Yes in the Confirm Perspective Switch dialog to verify switching to Database Debug perspective.

Triggers

Modify the launch configuration in the Edit Configuration and Launch page.

In the Run frame, add the SQL code to fire the trigger by using the SQL button to choose an insert, update, or delete command.
Select the tables whose attributes you want to modify and click Open. The Update (or Insert or Delete) Column Values pane appears.
Select the column to modify, and enter the values in the Values column, using the operators as needed and click OK.
Click OK and select Apply, and then choose Debug to execute the SQL code. Database Debug suspends execution at the first breakpoint. The SQL code appears in an editor window, displaying breakpoints. Detailed information on the execution appears under the Debug tab in the SQL Results view.