RE: CPYTOIMPF fails mysteriously

What is in the job log just before the cpc2957?
Jim


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
Charles Wilt
Sent: Thursday, June 20, 2019 11:54 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: CPYTOIMPF fails mysteriously

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

--
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