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.

DW with ou without Stored procedures???

2 posts in DataWindow Last posting was on 2008-06-04 15:11:39.0Z
Cristian A. Petersen Posted on 2008-06-04 13:37:04.0Z
From: "Cristian A. Petersen" <petersenca@petersen.com.py>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: DW with ou without Stored procedures???
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48469a80@forums-1-dub>
Date: 4 Jun 2008 06:37:04 -0700
X-Trace: forums-1-dub 1212586624 10.22.241.152 (4 Jun 2008 06:37:04 -0700)
X-Original-Trace: 4 Jun 2008 06:37:04 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87064
Article PK: 416321

Hello

PB 9.0.2

I would like to know your experiences, advantages and disvantages of using
DW with Stored procedures for (Select, Delete, Insert & update) and use it
with the sql embebed.
I never used with stored procedures before it looks more work to do, in the
other way looks very independent from the dbms. is it right?

Thanks,

Cristian


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-06-04 15:11:39.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48469a80@forums-1-dub>
Subject: Re: DW with ou without Stored procedures???
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4846b0ab$1@forums-1-dub>
Date: 4 Jun 2008 08:11:39 -0700
X-Trace: forums-1-dub 1212592299 10.22.241.152 (4 Jun 2008 08:11:39 -0700)
X-Original-Trace: 4 Jun 2008 08:11:39 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87066
Article PK: 416323

It depends on what the application needs. If you have a simple result set
SQL is clearly more straightforward and easy to do. If you need a
non-updatable view, have complex validations that involve a lot of SQL, or
have to reflect changes in tables other than the one being updated, you will
need to use stored procedures.
Some other thoughts:
I don't believe there is much difference in the overhead of DBMS
communication, but that's insignificant compared to the physical I/O that
the DBMS does internally.
You lose the ability to change the WHERE clause to control retrieval, but
that's really used more for reports.
You have another language to learn (T/SQL, PL/SQL , etc.) and debugging
becomes more complex.

"Cristian A. Petersen" <petersenca@petersen.com.py> wrote in message
news:48469a80@forums-1-dub...
> Hello
>
> PB 9.0.2
>
> I would like to know your experiences, advantages and disvantages of using
> DW with Stored procedures for (Select, Delete, Insert & update) and use it
> with the sql embebed.
> I never used with stored procedures before it looks more work to do, in
> the other way looks very independent from the dbms. is it right?
>
> Thanks,
>
> Cristian
>
>