Re: Declare a key on a subfile... is it possible?

Hi Charles - I'm assuming the data that you are using to fill in the
sub-file is NOT in zip code order. Therefore, why not populate a file (in
QTEMP) with the zip codes that have populated the su-file, checking first
to chain to that file in QTEMP to see if the zip code is found.

Alan


                                                                       
             "Charles                                                  
             St-Laurent"                                               
             <dringpiece@hotma                                          To
             il.com>                   rpg400-l@xxxxxxxxxxxx           
             Sent by:                                                   cc
             rpg400-l-bounces@                                         
             midrange.com                                          Subject
                                       Declare a key on a subfile... is it
                                       possible?                       
             04/14/2006 02:26                                          
             PM                                                        
                                                                       
                                                                       
             Please respond to                                         
              RPG programming                                          
              on the AS400 /                                           
                  iSeries                                              
             <rpg400-l@midrang                                         
                  e.com>                                               
                                                                       
                                                                       




Hi!

I want to fill a customer subfile by adding a record only if the zip code
is
not in what I've filled until now in the subfile. Is it possible to declare
a subfile with a key on a particular field of the subfile, so I will be
able
to chain in my RPG ILE program to find this particular value? Or must I
scan
all the subfile record by record to verify the presence of the searched zip
code?

One restriction in this project: I cannot use SQL, only pure RPG ILE for
V4R5 code.

Charles St-Laurent



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