How to debug stored procedures in Sybase ASE?

Question

Is there a good tool from either Sybase or elsewhere that will enable me to debug stored procedures in Sybase ASE? I need to be able to set breakpoints & watchpoints.

Previously, in Sybase ASA (not ASE), I used Sybase Central to do this. There is a plugin for ASE, but I doubt it will let me debug procedures.

Solution

Sybase ASE comes with a command line debugger called sqldbgr. Not the most user friendly option, but it does work. You can find documentation for this in the Utility Guide.

Alternatively Embarcadero produces a SQL debugger.

Comments

[CharlieBuckeroo]

Apologies. Debugger in Oracle SQL Developer works only for Oracle PL/SQL, not Sybase.

[B Johnson]

The above link to the Embarcadero site is now broken.

[sofs1]

Update this in the answer as PS: . I wasted some time by not reading the above comment. Thanks though.

[eric]

Also Aqua Data Studio from Aqua Fold has SQL debuggers for Sybase ASE and others

[Amit Joshi]

hello kindly update "SQL debugger." link. above one is expired.

[M Barzel]

Is there option in aqua data studio to run queries during debugging, and using temp tables and variables?

[eric]

yes! during a breakpoint you can run queries using the same connection/spid