Re: OPNQRYF & CPYTOIMPF ///

Jeff

I believe you need the OVRDBF, but not the shared ODP.

An alternative is a QM qrery - put this into a source member and CRTQMQRY
with it:

select * from custord where shpsts = ' '

Then STRQMQRY QRYNAME output(*outfile) outfile(libname/filename)

and then the CPYTOIMPF.

HTH

Vern

At 11:16 AM 12/16/2002 -0500, you wrote:

--
[ Picked text/plain from multipart/alternative ]
Morning all,


         I have an Interesting issue, that I probably should know the
answer to but can't seem to recall..

         CLP That does opnqryf selection from a PF.. Then is supposed to
use this ODP as the input to a cpytoimpf  but the cpy is ignoring
         the opnqryf and copying the entire file to the IFS..  What am I
missing, do I need an ovrdbf to specify an shared ODP ??

         TIA,
         JMS...

PGM

       OPNQRYF    FILE((CUSTORD)) QRYSLT('SHPSTS = '' ''') +
                           OPNSCOPE(*JOB)

             CPYTOIMPF  FROMFILE(CUSTORD) +
                          TOSTMF('/GFBF/orders.txt') +
                          MBROPT(*REPLACE) RCDDLM(*CRLF)

             CLOF       OPNID(CUSTORD)


Jeffrey Silberberg
CompuDesigns, Inc.
Atlanta, GA. 30350
(770) 399-9464
--

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