CPYFRMIMPF issue
Okay, here's the deal. I've got a tab delimited file that used to load perfectly fine into file using the CPYFRMIMPF command, using the following options;
CPYFRMIMPF FROMSTMF('/Directory of file/file.txt') TOFILE(Library/file) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE) FLDDLM(*TAB) RPLNULLVAL(*FLDDFT)
After much research, I'm pretty sure that the issue lies in the changes to the CPYFRMIMPF command in the V5R3 upgrade, since this is the only event that occured between the upload working and not working properly. The majority of records load without an error, but a few thousand don't make it to the AS400 file, and within the job log there is this error;
"Copy did not complete for reason code 7."
I've been informed that loading a PTF is NOT an avenue that I can pursue (even though I've found information that this would fix the problem!)
Any thoughts?
Software/Hardware used:
Software/Hardware used:
ASKED:
September 7, 2006 3:48 PM
UPDATED:
December 17, 2009 6:32 AM
Answer Wiki:
There's a message thread on the problem at http://archive.midrange.com/midrange-l/200409/msg00801.html which should help. The thread talks about CCSID's and CCSID 65535 and that prior to v5r3 the system used to use an interim file for the copy to get around the CCSID issue.
Jonathan
www.astradyne-uk.com
To see all answers submitted to the Answer Wiki: View Answer History.
The more I read about it, the more I am convinced that a true long term solution to inter-platform processing is Java or other OOP compiler.
The biggest factor for any cross-platform data movement will always be correct CCSID settings. The majority of AS/400 sites run with system CCSID 65535 even though it is defined as “binary/no translation” in network transactions. (That’s effectively the same as trying to do all FTP transfers as BINARY.)
And then the question eventually pops up — why do my data transfers not work?
Tom