CPYFRMIMPF only copies first field of each record

40 pts.
Tags:
AS/400
CPYFRMIMPF
iSeries
This is the CPYFRMIMPF command: CPYFRMIMPF FROMSTMF('/qdls/edenimpt/pymanded.ttx') TOFILE(BETTY/E941) MBR OPT(*ADD) FROMCCSID(37) RCDDLM(*CRLF) STRDLM('"') FLDDLM(',') RPLNULLVAL( *FLDDFT) This is the dds for E941: A R PR941R A EDEMP# 8 A LNAME 13 A FNAME 16 A GROSSPAY 12S 2 A NETPAY 12S 2 A FWTDED 12S 2 A MEDDED 12S 2 A SOCDED 12S 2 A WCBEN 12S 2

Answer Wiki

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

I ran into a very similar situation not too long ago. In my case there were CRLF values embeded in the data which cause an end of record condition and skewed the remainder of the file. Have you checked that actual data presenting the problem? Might be a good place to start.

Discuss This Question: 2  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
  • Qbjgqbjg
    CPYFRMIMPF only copies first field of each record I was able to get the records copied. I changed it to csv. It then only copied the records that did not have an amount. So I changed the numeric fields in the tofile to character. Then it worked. I would like to be able to have the numeric fields come in as numeric, but I can live with them as character.
    40 pointsBadges:
    report
  • TomLiotta
    Show an example of one of the lines from the streamfile. There shouldn't be a problem with numeric fields if they're represented properly. Tom
    125,585 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