Debug API for SQL Anywhere

I see that a product claims to have a debugger for SQL Anywhere. How is this achieved? Is there a debug API for SQL Anywhere?

features

asked 28 Jan '10, 23:44

Brad Wery
382●19●21●26
accept rate: 0%

edited 29 Jan '10, 11:06

Breck Carter
32.5k●541●726●1050

Just for curiosity - what product are you refering to (if not Sybase Central, as Breck has explained)?

(29 Jan '10, 21:12) Volker Barth

It's this company www.upscene.com. There must be a way to code this if they were able to do it.

(29 Jan '10, 23:38) Brad Wery

Why don't you have a look at that other product, see if the debugger is as good as the one that comes in the box? Personally, I don't see the point in writing utilities like a debugger or an execution profiler when the vendor ships fully-functional versions in-the-box.

(30 Jan '10, 08:18) Breck Carter

Of course, one could then ask "why Foxhound?" and the answer would be, "look at the one that comes in the box" :)

(30 Jan '10, 08:18) Breck Carter

flat view

One Answer:

active answers oldest answers newest answers popular answers

SQL Anywhere has had a stored procedure and trigger debugger since Version 6 was released in 1998. AFAIK there is no debug API, nor has there been many (any?) requests for it.

You get the debugger via Sybase Central; here's how, using Version 11:

(1) Open Sybase Central and connect to a database.

The "Mode" item will appear in the menu bar.

(2) Click on Mode - Debug.

The "Specify User to Debug" dialog box will appear.

(3) Click OK.

Three "Debugger Details" panes will appear.

(4) Open the source for a procedure or trigger or whatever in the top right pane.

(5) Right-mouse-click on the grey vertical bar to the left of a statement where you want to put a breakpoint... click on Insert Breakpoint.

(6) Run your application, or commands in dbisql, etc., to cause the procedure to be called.

(7) Switch back to Sybase Central... a yellow arrow will appear at the breakpoint.

And so on...

permanent link

answered 29 Jan '10, 11:03

Breck Carter
32.5k●541●726●1050
accept rate: 20%

So if I want to code this myself... how would I go about doing it? Are there procedures I can call?

(29 Jan '10, 23:41) Brad Wery

Like I said, there's no published API, no procedures to call AFAIK. I'm not gonna suggest "reverse engineer" since I think the license agreement forbids that.

(30 Jan '10, 08:15) Breck Carter

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

features ×8

question asked: 28 Jan '10, 23:44

question was seen: 3,018 times

last updated: 29 Jan '10, 11:06

SAP SQL Anywhere

Debug API for SQL Anywhere

Follow this question

Related questions