Debugging an External Client

Open the Database Development Perspective.

In the Database Explorer view, open the procedural object.

Put breakpoints into the procedural object; for example, a stored procedure.

Select Window|Show View|Other|Sybase Database Debug|External Clients to open the External Clients view.

Use the isql command line utility to connect to the database. Using isql command as an example, the following isql external client example finds the spid of a client session:

isql -U sa -P -S useridw2k

1> select @@spid

2> go

------

24

(1 row affected)

In the External Clients view, expand the connection profile associated with the database to which the external client is connected.

The new client is listed under the connection profile in the External Clients view.

Right-click the client from which you want to debug and select attach Client Connection.

From the client session, execute the procedural object opened in step 2.

A Confirm Perspective Switch dialog pops up informing you that it will switch to Database Debug perspective.

Click OK.

The client session is in a suspended state as the cursor is at the location of your first breakpoint in the SQL Editor.

Debug the client using step-in, step-over, or resume in Debug view.

Once debugging completes, the client session comes out of the suspended state as the cursor is at the location of your first breakpoint in the SQL Editor