Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Stored Proc Debugger

8 posts in Unix Last posting was on 2001-05-25 21:29:58.0Z
Anthony_Jules Posted on 2001-03-27 16:34:39.0Z
From: Anthony_Jules
Date: Tue, 27 Mar 2001 12:34:39 -0400
Newsgroups: sybase.public.sqlserver.unix
Subject: Stored Proc Debugger
Message-ID: <2B5BE3274BEED06A005B103885256A1C.005B104685256A1C@webforums>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.unix:688
Article PK: 1092777

Folks,
Does anyone know of any "strong" stored procedure debuggers
which allow: breakpoint setting, variable browsing,
line-by-line execution. We're using ASE 12.0, with a good
chunk of application logic written inside stored procs. A tool
of this nature would be of great assistance.

Thank you,
...Anthony


agzurich Posted on 2001-04-17 04:44:15.0Z
Message-ID: <3ADBCA1F.8BB1639C@super.net.pk>
Date: Tue, 17 Apr 2001 09:44:15 +0500
From: agzurich@super.net.pk
X-Mailer: Mozilla 4.7 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Stored Proc Debugger
References: <2B5BE3274BEED06A005B103885256A1C.005B104685256A1C@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.unix
Lines: 16
NNTP-Posting-Host: 203.130.7.85
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:603
Article PK: 1092694

There is another Procedure Debugging tool is available called
SP_Debugger, developed by Sigma Six, you can check the web site
http://www.sigmaweb.com

Bye
Tahir

Anthony_Jules wrote:

> Folks,
> Does anyone know of any "strong" stored procedure debuggers
> which allow: breakpoint setting, variable browsing,
> line-by-line execution. We're using ASE 12.0, with a good
> chunk of application logic written inside stored procs. A tool
> of this nature would be of great assistance.
>
> Thank you,
> ...Anthony


Eugene Korolkov Posted on 2001-05-25 21:29:58.0Z
Message-ID: <3B0ECED5.2D86AFF6@dgny.com>
Date: Fri, 25 May 2001 17:29:58 -0400
From: Eugene Korolkov <ekorolkov@dgny.com>
Organization: The Davidsohn Group
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: ru,en
MIME-Version: 1.0
To: agzurich@super.net.pk
Subject: Re: Stored Proc Debugger
References: <2B5BE3274BEED06A005B103885256A1C.005B104685256A1C@webforums> <3ADBCA1F.8BB1639C@super.net.pk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.unix
Lines: 23
NNTP-Posting-Host: 12.3.91.62
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:419
Article PK: 1092510

SP-Debugger, XPediter/SQL, DBPartner actually the
same tool developed in Powerbuilder originally by Alex Ginsburg.
Embarcadero during our conversation promised to start
selling debugger for Sybase in June.

HTH,
Eugene

agzurich@super.net.pk wrote:

> There is another Procedure Debugging tool is available called
> SP_Debugger, developed by Sigma Six, you can check the web site
> http://www.sigmaweb.com
>
> Bye
> Tahir
>
> Anthony_Jules wrote:
>
> > Folks,
> > Does anyone know of any "strong" stored procedure debuggers
> > which allow: breakpoint setting, variable browsing,
> > line-by-line execution. We're using ASE 12.0, with a good
> > chunk of application logic written inside stored procs. A tool
> > of this nature would be of great assistance.
> >
> > Thank you,
> > ...Anthony


Ngx Posted on 2001-05-25 13:51:52.0Z
From: ngx
Date: Fri, 25 May 2001 09:51:52 -0400
Newsgroups: sybase.public.sqlserver.unix
Subject: Re: Stored Proc Debugger
Message-ID: <F28C0568762C344E004C291985256A57.0019525E85256A3E@webforums>
References: <2B5BE3274BEED06A005B103885256A1C.005B104685256A1C@webforums> <3ADBCA1F.8BB1639C@super.net.pk>
Lines: 3
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.unix:422
Article PK: 1092512

You can take a look at pro.wanadoo.fr/ngx
Regds
Ngx


stharrell Posted on 2001-04-02 14:14:51.0Z
Message-ID: <3AC8895B.A1C81F0E@yahoo.com>
Date: Mon, 02 Apr 2001 09:14:51 -0500
From: stharrell@yahoo.com
X-Mailer: Mozilla 4.76 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Stored Proc Debugger
References: <2B5BE3274BEED06A005B103885256A1C.005B104685256A1C@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.unix
Lines: 17
NNTP-Posting-Host: 209.186.143.6
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:661
Article PK: 1092751

We use Xpediter/SQL and have had good luck with it. We've found a few
bugs, but for the most part, it works well. It's also not a huge
investment which is why we chose it over some of the other products
available.

Anthony_Jules wrote:

> Folks,
> Does anyone know of any "strong" stored procedure debuggers
> which allow: breakpoint setting, variable browsing,
> line-by-line execution. We're using ASE 12.0, with a good
> chunk of application logic written inside stored procs. A tool
> of this nature would be of great assistance.
>
> Thank you,
> ...Anthony


Bret Halford Posted on 2001-03-27 21:09:41.0Z
Message-ID: <3AC10195.9DC6039F@sybase.com>
Date: Tue, 27 Mar 2001 14:09:41 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Stored Proc Debugger
References: <2B5BE3274BEED06A005B103885256A1C.005B104685256A1C@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.unix
Lines: 17
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:683
Article PK: 1092772

I have no direct experience with these products, but here is a list of
the stored procedure
debuggers I have heard mention of:

CAST SQL Workbench
DB Artisian
Xpediter (from compuware)
RapidSQL

-bret

Anthony_Jules wrote:

> Folks,
> Does anyone know of any "strong" stored procedure debuggers
> which allow: breakpoint setting, variable browsing,
> line-by-line execution. We're using ASE 12.0, with a good
> chunk of application logic written inside stored procs. A tool
> of this nature would be of great assistance.
>
> Thank you,
> ...Anthony


Huib_van_der_Bolt Posted on 2001-03-28 14:11:45.0Z
From: Huib_van_der_Bolt
Date: Wed, 28 Mar 2001 10:11:45 -0400
Newsgroups: sybase.public.sqlserver.unix
Subject: Re: Stored Proc Debugger
Message-ID: <75CC03A42E8B77C8004DFB1185256A1D.0078C8A285256A1C@webforums>
References: <2B5BE3274BEED06A005B103885256A1C.005B104685256A1C@webforums> <3AC10195.9DC6039F@sybase.com>
Lines: 23
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.unix:682
Article PK: 1092773

Of this list, CAST (www.castsoftware.com) is by far the best. The big
problem is that you cannot buy the debugger and sql developer seperately.
You have to buy the total CAST workbench. In itself not a bad thing because
it is really a very good development tool for databases.
It also has very nice features for reverse engineering, impact analyses
(very nice) and making delta scripts for comparing two databases and
creating a script that will convert the one into the other.
However, you will find that whoever controls the budget will think
differently. You have to very dig deep in your purse for this product. I
advise you to get a trail version.

A very good substitute for just debugging is Xpediter/SQL, but I can't
really tell because I have no experience with it. I couldn't find it on the
compuware site anymore. The salesmen gave us a demonstration once. It is OK
for a debugger. It doesn't do much more.

Rapid SQL has no debugging for Sybase, only Oracle PL/SQL.
DBArtisan is more a DBA tool and also doesn't have a real debugger.

I hope this helps. If you have any more questions :
huib.van.der.bolt@gmx.net
If you find another alternative, I would like to know too.

Regards, Huib


Hew Posted on 2001-04-24 19:00:14.0Z
Message-ID: <3AE5CD3E.5D287F80@usa.net>
Date: Tue, 24 Apr 2001 14:00:14 -0500
From: Hew <hew@usa.net>
X-Mailer: Mozilla 4.75 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Stored Proc Debugger
References: <2B5BE3274BEED06A005B103885256A1C.005B104685256A1C@webforums> <3AC10195.9DC6039F@sybase.com> <75CC03A42E8B77C8004DFB1185256A1D.0078C8A285256A1C@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.unix
Lines: 34
NNTP-Posting-Host: 128.249.232.250
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:564
Article PK: 1092653

Xpediter/SQL is now DBPartner.

Huib_van_der_Bolt wrote:

> Of this list, CAST (www.castsoftware.com) is by far the best. The big
> problem is that you cannot buy the debugger and sql developer seperately.
> You have to buy the total CAST workbench. In itself not a bad thing because
> it is really a very good development tool for databases.
> It also has very nice features for reverse engineering, impact analyses
> (very nice) and making delta scripts for comparing two databases and
> creating a script that will convert the one into the other.
> However, you will find that whoever controls the budget will think
> differently. You have to very dig deep in your purse for this product. I
> advise you to get a trail version.
>
> A very good substitute for just debugging is Xpediter/SQL, but I can't
> really tell because I have no experience with it. I couldn't find it on the
> compuware site anymore. The salesmen gave us a demonstration once. It is OK
> for a debugger. It doesn't do much more.
>
> Rapid SQL has no debugging for Sybase, only Oracle PL/SQL.
> DBArtisan is more a DBA tool and also doesn't have a real debugger.
>
> I hope this helps. If you have any more questions :
> huib.van.der.bolt@gmx.net
> If you find another alternative, I would like to know too.
>
> Regards, Huib