RE: lazy, /dumb or inept programmer

Jeff,

I use SQL cursors mainly for user-defined subfile loads (sorry, Scott). I admit that I usually don't think about using SQL for most reports, even in cases when I should. But I don't really see much difference between loading subfiles and printing reports as far as SQL goes.

Of course, sometimes (rarely but sometimes) it's just easier to use the Cycle.

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Tuesday, February 23, 2010 3:31 PM
To: RPG programming on the IBM i / System i
Subject: Re: lazy, /dumb or inept programmer

None that I know of. I've done 20+ SQLRPGLE programs, but very very few are
report programs.

Can anyone guess why? Hint: that discussion surfaces here every so often.
It's about time once again.......AIEEE!

On Tue, Feb 23, 2010 at 4:04 PM, sjl <sjl_abc@xxxxxxxxxxx> wrote:

Yes - how could you otherwise handle a SQL statement that returns multiple
records?

- sjl



Jeff wrote:
All of you using RPG+SQL for reports instead of OPNQRYF,
I assume you're using a cursor in RPG?



--
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.