RE: CHAIN to a DS

["John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>]

Pardon me for being stupid here, but why not do a single copy and
set triggers on the physicals that all call the same trigger program
that writes the file you want to write?
Then you don't have all the copying of data and a single source for
updating your "Master" file. 

John Brandt
iStudio400.com
(903) 523-0708
Home of iS/ODBC - MSSQL access FROM iSeries.

-----Original Message-----
From: CarollaT@xxxxxxxxxxxxxx [mailto:CarollaT@xxxxxxxxxxxxxx]
Sent: Friday, September 03, 2004 2:14 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: CHAIN to a DS


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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.749 / Virus Database: 501 - Release Date: 9/1/04
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.749 / Virus Database: 501 - Release Date: 9/1/04