RE: Is this unusual? OPNQRYF | CPYFRMQRYF

["Doug Palme" <dpalme@xxxxxxxxxxx>]

I am not the one running it, I would have not used opnqryf myself and yes it
does take a while to run (about 4 hours).

I was trying to figure out why they were running at the same time.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pat Barber
Sent: Wednesday, February 21, 2007 9:03 AM
To: Midrange Systems Technical Discussion
Subject: Re: Is this unusual? OPNQRYF | CPYFRMQRYF

That doesn't sound correct. Cpyfrmqryf needs a open
data path to copy from. Job logs are not real clear
when checking on opnqryf.

That's a really large file to be using opnqryf against.
That job must run for a while ? Wouldn't a logical
make more sense ? Is the job doing record selection or
just using opnqryf to sort the file ?

You could actually end up with "2" files of 25mb using
this method.


Douglas Palme wrote:

> We are running a CL in batch that is opening a query file over a PF with
> approx 25m records, the next line of code is CPYFRMQRYF.

> In checking the job log it appears that BOTH are running simultaneously.