RE: e-Arranging a spool file

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
postage.

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.

John
DRV Technologies, Inc.
www.drvtech.com




-----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.