RE: RPG SQL and Cursors

(Cross-posted to midrange-l) I have never seen that phrase adequately
explained (let alone justified). From recent exchanges, my take on it is
that it's a cute (in some eyes) way of saying that you should use standard
F-spec type file I/O if you need cursor-type operations. The thinking, as I
understand it, being that SQL cannot compete with such operations.

I completely disagree with that sentiment, but that's my take - right or
wrong.

Then again, I'm not sure I have ever agreed with anyone who will only tell
you what's wrong, and not what's right to correct it.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
He who laughs last, thinks slowest.

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.