Re: opnqry file v cpyf

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