CPYFRMIMPF issue

pts.
Tags:
AS/400
DB2 Universal Database
RPG
RPGLE
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dynamic
    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.
    0 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • dinuas400
    If you get the reason code 7 mostly u can use this field in CPYFRMIMPF command RPLNULLVAL(*FLDDFT)
    510 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following