RE: how to duplicate this mainframe process on iSeries?

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

Michael,

I would recommend a single file with multiple members.  For each data
gather create a new member in the physical file.  At the end of the day
when it's time to process the data you could use the OVRDBF command MBR
parameter to specify all members.  When the processing is done remove
the members.  The DSPFD command with *MBRLIST for type of information
and *OUTFILE for output type will provide a list of members you could
loop through.

Rick

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Rosinger
> Sent: Monday, January 08, 2007 1:05 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: how to duplicate this mainframe process on iSeries?
>
> List,
>
> Here's another unusual process we have on our VSE mainframe
> that will have to be duplicated on the iSeries. I am hopeful
> that the iSeries can handle this in a much easier manner than
> does VSE, but I am too new to the environment to know.
>
> Here's the process on VSE....
>
> During the day, depending on which customers' data has
> arrived, it is processed and their data "staged" to a
> sequential file in a specific VSAM catalog. Throughout the
> day, more data files are generated. When it is time to begin
> the nightly run, we have to "gather" these files together
> (merge to a single dataset) and then purge the original
> individual files. (the catalog is backed up before the process begins)
>
> The way this process is currently handled is a COBOL program
> reads the VSAM catalog, looking for datasets whose name
> matches specific templates. This program generates JCL for a
> second job where another COBOL program will process each of
> the specific files passed in the list that the first program
> prepares. There is only one input file defined in this
> program. Before each input file open, an assembler routine is
> called which overrides the "ASSIGN TO name" of the file
> hardcoded in the ASSIGN clause of the program with one that
> is passed to the program in the list. This way it opens and
> processes each file dynamically according to the list for that day.
>
> If the iSeries provides a way to concatenate files of a
> similar format with names that match certain template(s) to a
> single file, this will be a piece of cake. The constraints here are:
>
> 1) there will be one-to-many of these files for any given run
> - but all in the same library
> 2) the files will be identified by one of several "strings"
> in their physical names
> 3) it is possible there could be other files in the same
> library but are irrelevant to this process (so #2 is very important)
>
> How best to accomplish this on the iSeries?
>
> --
> Regards,
>
> Michael Rosinger
> Systems Programmer / DBA
> Computer Credit, Inc.
> 640 West Fourth Street
> Winston-Salem, NC  27101
> 336-761-1524
> m rosinger at cciws dot com
>
>
> --
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list To post a message email:
> MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
> please take a moment to review the archives at
> http://archive.midrange.com/midrange-l.

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.