RE: Chaining with a very large file

I submit a job for each employee, they run in a multi-threaded jobq ( 10 at
a time) for each employer. At most two employers rebadging at once. That
gives twenty at a time. That is about all the system can handle and still
give reasonable response time to all the other jobs. The whole process will
take about two months, I think.
Tom

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Booth Martin
Sent: Wednesday, February 01, 2006 9:33 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Chaining with a very large file

ah, I see.

Then the only other thought I would have on this is to use data queues. 
  That allows several employee numbers to run at the same time.



Tom Huff wrote:
> I am not sure what you mean. 
> Yes, I am changing every record, but not at the same time. We are
rebadging
> the employees one at a time as they come in to get new badges. And
compared
> to SQL, the programs do fly. There are 600 plus files, and RPG reads all
of
> them and renumbers the employee in a little over 1 minute. Cant get much
> faster that that. That includes the time to call multiple programs (6 as I
> recall) each processing about 100 files. I know there are more elegant
ways
> of doing this, but this is not going to stay in production after everyone
is
> completed. Consequently, I wrote it as fast as I could.
> Thanks
> Tom