RE: Bundling Spool Files

We had almost this exact problem of needing to bundle month-end rpts
together to make mailings easier.  Unfortunately, there is was no easy
solution (at least at that time that we could find).  We ended up copying
the spool files to database files and then creating an index with the
beginning and ending record number for each customer for each of the rpts.
Then working backwards with the index by customer, we copied the records
from the database files back to a spool file combining each of the customers
rpts into one spool file.  This way you can print out each customers
multiple rpts together.  It was not quick and easy, but it worked.  You just
have to make sure that each of the rpts has something in a specific spot at
the beginning of each customers rpt so it can be recognized as a break when
you're creating the index.
HTH

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of alan shore
> Sent: Wednesday, May 24, 2000 8:39 AM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Bundling Spool Files
>
>
> I may be mistaken, but I think the original request was NOT
> strictly bundling the spool files together, but sorting the
> contents of those spool files so that customer A has
> statements/invoices/bills from spool 1,2,3 and 4, followed by
> customer B from spool 2 and 4 followed by customer C from spool 1
> and 3. I hope that my interpretation is correct as I am in the
> process of analyzing the same problem, and if anyone has an
> answer, obviously, I would be very interested.
> TIA
>
> >>> Dave Murvin <davem@drme.com> 05/23 9:13 PM >>>
> If the programs you are using use the same printer file, such as QSYSPRT,
> you could use OVRPRTF FILE(QSYSPRT) SHARE(*YES), then all the
> printer files
> after the override (assuming they are the same file name and in the same
> job) will be bundled into the one spool file.  I have used this
> process in
> the past to connect cover page info to a report so when you print two
> copies, the cover pages are attached to the reports.
>
> At 06:39 PM 5/23/00 +0200, you wrote:
>
> >Is there an "easy" way to programmatically bundle the spool
> files together,
> >so that the contents of the spool files will be printed in the correct
> >sequence?
>
> Dave Murvin
> DRM Enterprises, Inc.
> davem@drme.com
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---