Re: opnqry file v cpyf

[Boykie <Midrange@xxxxxxxxxxx>]

Paul.

herewith my humble opinion - plse bear in mind that I speak from
experience in the distant past....
personally, I would not use CPYF.

There is ongoing debate between OPNQRYF and FMTDTA, and the performance
of either.
the comparative performance seems to change with each release as each is
improved,
and the net result is that they are fairly close in performance <at
the moment>

By 'Query400', your instructors/requestors  might mean
OpenQueryFile,  or,  Query Manager.
As far as I know, Query Manager uses SQL, and that may be the way they
wanted ..

I am by no means an expert in any of these areas,
but throw this out there to elicit a response for you..

good luck,

kmh



At 08:29 AM 7/28/2001, you wrote:
> hello
> when i want to retrieve records from a file
> with certain criteria is there a preferred way  rather than using
> open qry file with selects... perhaps using cpyf to a file in qtemp and
> using increl to select records..... as a novice are there particular
> performance issues of either way   this relates to a 
> particular task where i was asked to  use  query400 (using this
> file and another file for the customer name ) to output  a printer
> file depending on the user entering date and customer or just date.....
> or would doing this in a rpg pgm reading the file have been
> better
> paul h