I just tried the command against one of our files, placing the csv in my directory on the ifs with NO problems
I know you said that FOO/BAR is an externally defined file – but can you post the DDS or file layout
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
From: Jack Woehr [mailto:jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, June 20, 2019 11:50 AM
To: Alan Shore <ashore@xxxxxxxx>
Cc: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [EXTERNAL] CPYTOIMPF fails mysteriously
Same error
Message ID . . . . . . : CPC2957 Severity . . . . . . . : 00
Message type . . . . . : Completion
Date sent . . . . . . : 06/20/19 Time sent . . . . . . : 10:47:43
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.
On Thu, Jun 20, 2019 at 9:46 AM Alan Shore <ashore@xxxxxxxx<mailto:ashore@xxxxxxxx>> wrote:
Hi Jack
Then you need to change the command
Try this as a start
Notice what was removed and what was added
CPYTOIMPF FROMFILE(FOO/BAR) TOSTMF('/home/JWOEHR/foobar.csv') MBROPT(*REPLACE) RCDDLM(*CRLF) ADDCOLNAM(*SQL)
--
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.
midrange.com
