Re: OPNQRYF & CPYTOIMPF ///

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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.