Re: CPYTOIMPF fails mysteriously

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Dumb question, are you sure there's data in FOO/BAR?

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