Hi all,

I'm looking for some Sybase database client app, that can help me
debugging stored procedures on remote server.

Any suggestions? (Preferably kind of Eclipse plugin?

Regards,
Chris A.

In article <gnjmub$t1m$1 (AT) nemesis (DOT) news.neostrada.pl>,
krzysztof_DOT_adamczyk (AT) gmail_CUT_ (DOT) com says...
Which sybase database are you using?



--
/~\ The ASCII
\ / Ribbon Campaign
X Against HTML
/ \ Email!

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

David Kerber wrote:
It's Sybase ASE.

Regards,
Chris

On Feb 19, 2:21*pm, Krzysztof Adamczyk
<krzysztof_DOT_adamczyk (AT) gmail_CUT_ (DOT) com> wrote:
I assume you mean ASE.

Sybase Workspace can do this. I believe that Aqua Data Studio also
works.

SQL Browser (www.sqlbrowser.com) takes a slightly different approach
(parses the SQL proc code, then runs it as an interpreter executing
each statement in turn). This is something that is actually very
efficient, and it's the tool that I use for SQL development.

Michael

Hello,

In addition to Sybase Workspace, there is a small command line
debugger
that is shipped with ASE 12.5.x and 15.0.x in $SYBASE/$SYBASE_ASE/bin:

http://infocenter.sybase.com/help/to...utility216.htm

nstack-sun% pwd
/software/ase1502/ASE-15_0/bin

nstack-sun% sqldbgr -U tester -P tester1 -S nstack-sun:5502
$SYBASE_JRE is set. Use $SYBASE_JRE as $JAVA_HOME.
(sqldbg) help

(attach, detach, sql, mysql, cont, stop, step, next, run, show, set,
disable, enable, quit, exit, help all)
(sqldbg) help sql
sql <sql stmt>
(Run the sql statement inside the debugger.
Useful for getting temp table info of the debugged task)
(sqldbg) help stop
stop in <procname> (Stop in beginning of a procedure)
stop in <procname> at <line#>
(Stop at a valid line number in the procedure.
Automatically moves the breakpoint to the next valid line)