Home > IT Answers > AS/400 > CPYFRMIMPF only copies first field of each re...
Help

Question

  Asked: Apr 29 2008   6:46 PM GMT
  Asked by: Qbjgqbjg

CPYFRMIMPF only copies first field of each record


CPYFRMIMPF, AS/400, 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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 30 2008  1:43 PM GMT  by Pmc




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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Qbjgqbjg  |   May 1 2008  1:48PM GMT

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.