Re: CPYF question

I just had to deal with the same situation. CPYF is way slow. I wrote
embedded SQL. Only recommendation would be to map a user space into an array
and write 32766 records at a shot or what will fit in the user space or use
teraspace to allocate the array. Will be too slow otherwise.

On Thu, May 7, 2009 at 12:52 PM, sjl <sjl_abc@xxxxxxxxxxx> wrote:

All -

Thanks for the suggestions. The file is the JDE General Ledger detail
(F0911).

How about this solution:

There is not currently a logical file containg the fields necessary for
optimizing the SQL if used, so I'm going to recommend that we

1) Build either a new logical file or create a SQL index, and
2) Replace the CPYF with an RPGIV program with embedded SQL to perform the
copy, passing the variable values via JDE's Dream Writer processing
options.

- sjl

"sjl" <sjl_abc@xxxxxxxxxxx> wrote in message
news:mailman.5621.1241649683.23468.midrange-l@xxxxxxxxxxxxxxx
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





--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.