ASE Database forum - stored procedures debugger tools

Author

stored procedures debugger tools

Roberto Lammoglia

2005-04-19, 7:24 am

Dear all,
someone know if there is a tool to debug stored procedures (with a
breakpoint, variable view etc etc).....

Thank
Roby

Rob Verschoor

2005-04-19, 7:24 am

"Roberto Lammoglia" < NOSPAMrlamm@becromal
.it> wrote in message
news:4264d116$1@foru
ms-1-dub...
> Dear all,
> someone know if there is a tool to debug stored procedures (with a
> breakpoint, variable view etc etc).....
>
> Thank
> Roby

As of 12.5, there's a command-line debugger named sqldbgr (on NT:
sqldbgr.bat), located in the ASE-12_5/bin subdirectory. Connect with the
usual -U/-P/-S options (leave a space between each parameter and the value).
Once connected, type 'help', help all' or 'help <command>' at the prompt.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

Roberto Lammoglia

2005-04-19, 7:24 am

Dear Rob,
unfortunately i must work on an old 11.9.2 version of ASE.....
Do you know some other tools ????

TIA
Roby

"Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
message news:4264e21c$1@foru
ms-1-dub...
> "Roberto Lammoglia" < NOSPAMrlamm@becromal
.it> wrote in message
> news:4264d116$1@foru
ms-1-dub...
>
>
> As of 12.5, there's a command-line debugger named sqldbgr (on NT:
> sqldbgr.bat), located in the ASE-12_5/bin subdirectory. Connect with the
> usual -U/-P/-S options (leave a space between each parameter and the
value).
> Once connected, type 'help', help all' or 'help <command>' at the prompt.
>
> HTH,
>
> Rob
> -------------------------------------------------------------
> Rob Verschoor
>
> Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
> and Replication Server 12.5 / TeamSybase
>
> Author of Sybase books (order online at www.sypron.nl/shop):
> "Tips, Tricks & Recipes for Sybase ASE"
> "The Complete Sybase Replication Server Quick Reference Guide"
> "The Complete Sybase ASE Quick Reference Guide"
>
> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> http://www.sypron.nl
> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
> -------------------------------------------------------------
>
>

Eugene Korolkov

2005-04-19, 11:24 am

Roberto,

Take a look on:
Cast workbench SQL Builder (for all versions I 'am guessing),
Dbartisan by Embarcadero (debugger only for 12.5)

Regards,
Eugene

Roberto Lammoglia wrote:

>Dear Rob,
>unfortunately i must work on an old 11.9.2 version of ASE.....
>Do you know some other tools ????
>
>TIA
>Roby
>
>
>"Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
>message news:4264e21c$1@foru
ms-1-dub...
>
>
>value).
>
>
>
>
>
>

Rob Verschoor

2005-04-20, 3:24 am

Unfortunately, no.
BTW -- the DBArtisan debugger (mentioned in another post in this thread)
uses the same API as sqldbgr, i.e. you need ASE 12.0+ for this.
Really, 11.9 is terribly old now. If you can, upgrade to 12.5.x...

HTH,

Rob V.

"Roberto Lammoglia" < NOSPAMrlamm@becromal
.it> wrote in message
news:4264ecae$1@foru
ms-2-dub...
> Dear Rob,
> unfortunately i must work on an old 11.9.2 version of ASE.....
> Do you know some other tools ????
>
> TIA
> Roby
>
>
> "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
> message news:4264e21c$1@foru
ms-1-dub...
> value).
prompt.[color=darkred]
>
>

Alexey Danilov

2005-04-21, 3:24 am

Hello, Roberto!
You wrote on 19 Apr 2005 04:34:11 -0700:
http://pro.wanadoo.fr/ngx
Cool debugger !!

With best regards, Alexey Danilov. E-mail: dan@pharm.mos.ru

Alexey Danilov

2005-04-22, 3:24 am

Hello, Alexey!
You wrote to Roberto Lammoglia on 21 Apr 2005 01:01:11 -0700:

AD> Hello, Roberto!
AD> You wrote on 19 Apr 2005 04:34:11 -0700:
AD> http://pro.wanadoo.fr/ngx
AD> Cool debugger !!
Just now it on http://www.sqlbrowser.com

AD> With best regards, Alexey Danilov. E-mail: dan@pharm.mos.ru

With best regards, Alexey Danilov. E-mail: dan@pharm.mos.ru

Roberto Lammoglia

2005-04-22, 9:24 am

Alexey,
it's wonderful !!!!!

Thanks, thanks, thanks
Roby

"Alexey Danilov" <dan@pharm.mos.ru> wrote in message
news:602837945@domai
n...
> Hello, Alexey!
> You wrote to Roberto Lammoglia on 21 Apr 2005 01:01:11 -0700:
>
> AD> Hello, Roberto!
> AD> You wrote on 19 Apr 2005 04:34:11 -0700:
> AD> http://pro.wanadoo.fr/ngx
> AD> Cool debugger !!
> Just now it on http://www.sqlbrowser.com
>
>
> AD> With best regards, Alexey Danilov. E-mail: dan@pharm.mos.ru
>
>
> With best regards, Alexey Danilov. E-mail: dan@pharm.mos.ru
>
>

Sponsored Links