RE: CHAIN to a DS

[MWalter@xxxxxxxxxxxxxxx]

Maybe SQL instead of Native since you're working on sets of records

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                                
                                                        
                      CarollaT@medameric                                        
                                                        
                      a.com                     To:       rpg400-l@xxxxxxxxxxxx 
                                                        
                      Sent by:                  cc:                             
                                                        
                      rpg400-l-bounces@m        Subject:  RE: CHAIN to a DS     
                                                        
                      idrange.com                                               
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      09/03/2004 03:14                                          
                                                        
                      PM                                                        
                                                        
                      Please respond to                                         
                                                        
                      RPG programming on                                        
                                                        
                      the AS400 /                                               
                                                        
                      iSeries                                                   
                                                        
                                                                                
                                                        
                                                                                
                                                        




[Bill Heinz wrote]

Would CPYF FROMFILE(FILE1) TOFILE(FILE2) MBROPT(*UPDADD) work for you?

[/]



No, because there is one additional field in the to-file, which indicates
which library the TRANS file was in.



Basically, I have 60+ of these TRANS files, in different libraries, and the
file I am updating is one file containing all records from all files.  I
want to update the master file based on updates/adds only, because this
program will generate a web page throughout the day (currently every half
hour, we want it every 15 minutes or less)  indicating to individuals
(three
letter ones, CEO, CIO, etc.) our performance.



Besides, I don't think that 60+ CPYF commands would run near as fast as
using the journaling approach.

Thanks



Tony Carolla

MedAmerica Billing Services, Inc.

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