Re: CPYTOIMPF fails mysteriously

[Charles Wilt <charles.wilt@xxxxxxxxx>]

And does it work with another file?

Lastly, does '/home/JWOEHR' exist?

Charles

On Thu, Jun 20, 2019 at 10:04 AM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

> OS version?  PTF Level?
>
> I've seen PTFs for CPYxxxIMPF
>
> Charles
>
> On Thu, Jun 20, 2019 at 9:09 AM Jack Woehr <
> jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > The command
> >
> > CPYTOIMPF FROMFILE(FOO/BAR *ALL) TOSTMF('/home/JWOEHR/foobar.csv')
> > RCDDLM(*CRLF) ADDCOLNAM(*SQL)
> >
> > and every variation thereof I have tried fails as follows:
> >
> > Message ID . . . . . . :   CPC2957       Severity . . . . . . . :   00
> >
> > Message type . . . . . :   Completion
> >
> > Date sent  . . . . . . :   06/20/19      Time sent  . . . . . . :
> > 10:06:08
> >
> >
> > Message . . . . :   No records copied from file BAR in FOO.
> > Cause . . . . . :   No records were copied from member or label BAR in
> >   file BAR in library FOO because the from-file member or label did not
> >   contain records or records did not meet the selection requirements.
> >
> > Technical description . . . . . . . . :   If the from-file or to-file
> > member
> >   or label name is *N, the file is a printer, nonlabeled tape, or a inline
> >
> >   data file. If the from-file library name is *N, the file is a inline
> > data
> >
> >   file. Records are copied based on the following selection requirements:
> >
> >     -- For CPYF command, character values specified on the INCCHAR
> > parameter.
> >     -- For CPYF command, field values specified on the INCREL parameter.
> >
> >     -- For CPYFRMQRYF command, query selection specified on the OPNQRYF
> >
> >   command.
> >
> >
> > This seems to be complete nonsense. Everything exists. Any tips?
> >
> > --
> > Jack Woehr
> > Absolute Performance, Inc.
> > 12303 Airport Way, Suite 100
> > Broomfield, CO 80021
> >
> > NON-DISCLOSURE NOTICE:  This communication including any and all
> > attachments is for the intended recipient(s) only and may contain
> > confidential and privileged information.  If you are not the intended
> > recipient of this communication, any disclosure, copying further
> > distribution or use of this communication is prohibited.  If you received
> > this communication in error, please contact the sender and delete/destroy
> > all copies of this communication immediately.
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com