Re: First go at embedded SQL ... With a subfile.

[Alan Shore <AlanShore@xxxxxxxx>]

Hi Dave - I also looked into using SQL for subfiles. I am assuming that you
are going to be using load a page at a time subfiles.
This in SQL by itself should be no big deal as you would be using the SQL
FETCH NEXT for reading forward, the SQL FETCH PRIOR (as well as the SQL
FETCH RELATIVE -1 (or -2, or -3, or -4 etc) for reading backward. The
problem is when a user wishes to position the sub-file at a certain point.
There is no KEYed fetch within SQL. (NOTE - if anyone knows that I am
wrong, please let me know as I would dearly love to use whatever procedure
anyone can present).



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx


                                                                       
             "Turnidge, Dave"                                          
             <DTurnidge@OldRep                                         
             ublicTitle.com>                                            To
             Sent by:                  "RPG programming on the AS400 / 
             rpg400-l-bounces@         iSeries" <rpg400-l@xxxxxxxxxxxx>
             midrange.com                                               cc
                                                                       
                                                                   Subject
             11/03/2006 04:26          First go at embeded SQL ... With a
             PM                        subfile.                        
                                                                       
                                                                       
             Please respond to                                         
              RPG programming                                          
              on the AS400 /                                           
                  iSeries                                              
             <rpg400-l@midrang                                         
                  e.com>                                               
                                                                       
                                                                       




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

--
This is the RPG programming on the AS400 / iSeries (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.