Re: CPYF question

[Alan Campin <alan0307d@xxxxxxxxx>]

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.