Launch a database debug session for a procedural object from its corresponding editor if you want to make changes to the procedural object before debugging.
-
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 select
Edit.
-
In the Source page, right-click and select
Debug.
| Procedural object |
Debug method |
|---|
| Stored procedure or event |
If the procedural object has parameters, change parameter values as
needed, or click Load Default. When done, click
OK.
|
| Trigger |
Edit the launch configuration, and click Debug. |
The SQL code executes to the first breakpoint.
-
Click
Yes to verify
switching to the Database Debug perspective.