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
key field
- 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
important projects.

DRV Technologies, Inc.

-----Original Message-----
From: Adam West [mailto:adamster@xxxxxxxxx]
Sent: Saturday, August 09, 2008 10:40 PM
To: RPG400-L@xxxxxxxxxxxx
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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by 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 [javascript protected email address].