RE: First go at embeded SQL ... With a subfile.

Take a peek in the docs for SCROLL CURSOR.  This is a variation on the standard 
cursor (reads forward by default) which allows you to read forward/backward 
with relative positioning.  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Turnidge, Dave
Sent: Friday, November 03, 2006 3:27 PM
To: RPG programming on the AS400 / iSeries
Subject: First go at embeded SQL ... With a subfile.


Well, I've jumped in over my head with this one... I wrote my first
maintenance program using a boilerplate source kindly given to me by Don
Nitke. (Thank you Don!) It actually looks pretty good AFAIAC. 

What I want to do is to be able to change the sort sequences in the
subfile. I think I could do this with multiple logicals, but I want to
know if this is possible with SQL, and therefore not need the logicals.

In starting my conversion, (and I'm just trying to replace the current
logic - additional sorts to come later), I'm beginning to slog through
Roll Forward and Back, getting the specific record I want to edit, and
updating that record. Can anyone point me in a more logical direction
than I am seeing now?

The SQL that I am using just reads forward, like READ. I got to Roll
Back, and got stuck with trying to find out what is the equivalent in
SQL for READP... My first embedded SQL program was just a list. No
problem (when I finally got it finished). But this is looking like a
major project. Any comments on reducing the perceived size of this
monster?

Any suggestions appreciated.

Dave