Re: RPG SQL and Cursors

[<dieter.bender@xxxxxxxxxxxx>]

Hi Charles,

what's the alternative? RBARBARBARBAR with record level access???

Dieter

--------------------------------------------------
From: "Charles Wilt" <charles.wilt@xxxxxxxxx>
Sent: Thursday, November 18, 2010 9:23 PM
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Subject: Re: RPG SQL and Cursors

> Surprisingly, nobody's thrown my name out here yet...but "if you're
> using a cursor you're probably doing something wrong" is definitely a
> phrase I've thrown out here many times.
>
> The point being SQL is designed for sets or records, but to many
> people do things row by row since that what they are used to.
>
> It's not just our platform, happens on other too.  One of the MS SQL
> Server guru's coined the term RBAR - Row By Agonizing Row....pherhaps
> I'll steal it :)
>
> Sometimes cursors are the right or the only way to do something...but
> too often they are a poor choice.
>
> In any event, like Scott, I'm confused as to what you're asking.
> SQL-CLI doesn't really factor into the use or non-use of cursors.
>
> What do you want to do?
>
> Charles
>
> On Thu, Nov 18, 2010 at 12:34 PM, Jeff Young <cooljeff913@xxxxxxxxx> 
> wrote:
> > I have seen it indicated in many posts in the past that if you are using 
> > cursors
> > in SQL, you are doing something wrong.
> > If I have only RPGLE and CL to work with and SQL-CLI is not an option, 
> > how would
> > I select multiple rows for a set of conditions and return them in an 
> > ordered
> > condition using embedded SQL with a CURSOR?
> >
> > Thanks,
> >
> > Jeff Young
> > Sr. Programmer Analyst
> > IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions 
> > V5R2
> > IBM  Certified Specialist- e(logo) server i5Series Technical Solutions
> > Designer V5R3
> > IBM  Certified Specialist- e(logo)server i5Series Technical
> > Solutions Implementer V5R3
> > --
> > This is the RPG programming on the IBM i / System i (RPG400-L) mailing 
> > list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing 
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.