RE: CPYF question

If you have an index on the selection fields, Period numbers, you can
use any query tool such as QPNQRYF or SQL and it will only read the
necessary records. If you do not have any index on the selection
fields, RPG IP may work best. To build a temporary index for the query
will take a long time with 140 million records. If you know how the
file is organized, such as you always write to the end of the file and
the periods are sequential, you can save the last RRN found from the
previous quarter and then start reading by RRN, selecting your records.
(I hate that approach but still have a S36 Direct file that is
internally defined and it is very fast. Just never do a file reorg.)



Chris Bipes
Director of Information Services
CrossCheck, Inc.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of sjl
Sent: Wednesday, May 06, 2009 3:40 PM
To: midrange-l@xxxxxxxxxxxx
Subject: CPYF question

We are using a CPYF to select a subset of our G/L detail file (that has
140,000,000 records) into an extract file. It is taking a loooong time,
as
you can imagine. The record selection criteria will be different each
quarter, but it is basically selecting the posted G/L records for the
quarter (a range of range of period numbers) for the current fiscal
year.

Anyone have some suggestions for speeding it up? Maybe using OPNQRYF
with a
CPYFRMQRYF ?

- sjl