Debugging an External Client

Open the Database Development perspective.

In Enterprise Explorer, open the procedural object.

Put breakpoints into the procedural object.

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 and determine the spid, or process identifier, of the connection:

isql -U sa -P -S useridw2k
1> select @@spid
2> go
------
24
(1 row affected)

In External Clients, 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 for the spid matching that of your isql connection.

From the client session, execute the procedural object you opened.

The Confirm Perspective Switch dialog opens 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.

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

After debugging completes, the client session comes out of the suspended state as the cursor is at the location of your first breakpoint.

Note: When you terminate the debugging session for an external client, the client connection is detached, but the client session remains. For example, if the client session is an isql session, terminating the debugging session detaches the isql session from the debugging tool, but the isql session is not terminated.