Probably the easiest way for you to do this is:
- Copy your spooled file to a database file using *FCFC
(which also has a key field in it)
- Write a program to read the database file and populate the
- Copy the keyed database file back to a spooled file.
Keep in mind the time it will take you to write this
program, test and modify a couple of times. Then when you
get this done and other departments hear what you did watch
others come to you wanting to re-arrange their reports.
We have customers that love to have statements and invoices
print out in zip code sequence so they can pay reduced
We have others that like to print file copies (invoices etc)
in company name sequence so the filing is done much quicker
We even have customers that like to have their check runs
print in amount sequence in descending order.
(the check number is in the spooled file)
You should consider a 3rd party product (such as our
SpoolFlex) that allows you to re-sequence any spooled file
in 5 minutes.
For a couple thousand dollars you can easily save your
company more then that and you can work on bigger more
DRV Technologies, Inc.
From: Adam West [mailto:adamster@xxxxxxxxx]
Sent: Saturday, August 09, 2008 10:40 PM
Subject: e-Arranging a spool file
HI I have a report that is printing by Invoice number. It is
used as a kind of picking/packing sheet by the warehouse.
What they would like would be to print the report by Model
number for efficiency.
Since this is an old cycle RPG report I am hesitant to
change the structure of the program. I would rather look at
the spool file and get the model number and redo the order.
I was wondering if this is an easy task to do.
The other option I guess would be to add a work file to the
program and as a separate report print the recap of what is
needed to be picked. But I think they would prefer not to
be cluttered with yet another stack of papers.
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact