Hi Jack
This is telling me that you have a multi member file (FOO/BAR) that you want to copy to an EXISTING file ('/home/JWOEHR/foobar.csv')
However - I believe that the system is telling you that the formats between the 2 are different
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Jack Woehr
Sent: Thursday, June 20, 2019 11:09 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] CPYTOIMPF fails mysteriously
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
midrange.com
