Copy File from PC file to Iseries- Change record length.
Home > IT Answers > AS/400 > Copy File from PC file to Iseries- Change rec...
Brenry
5 pts.
0
Q:
Copy File from PC file to Iseries- Change record length.
iSeries, CPYFRMIMPF, CPYFRMPCD, CPYFRMSTRMF
I am trying to copy a PC text file and copy it in a wrapping format to an ISeries DB File with a single 128 length field. I am trying CPYFRMIMPF, CPYFRMPCD, CPYFRMSTRMF and they all seem to cut off part of the record. Can this be done short of counting characters in a record?

Software/Hardware used:
Windows, ISeries
ASKED: Oct 8 2009  7:45 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
CharlieBrowne
6350 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Sounds like you are trying to copy a long character string into a flat file and for a single input record you want to output multiple records.
I do not believe you can do that in one step.
You would have to copy it to a longer file and then use SQL or a program to split it into multiple records.
Another option would be to copy into a file that had a variable length field,
Last Answered: Oct 8 2009  8:08 PM GMT by CharlieBrowne   6350 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

TomLiotta   7670 pts.  |   Oct 9 2009  10:50PM GMT

Maybe the simplest option is to use FTP. You can FTP on the same system from a streamfile into a flat file, and, IIRC, FTP will do that kind of wrapping. (I haven’t needed to disturb lines like that, so I haven’t actually seen such wrapping.)

Tom

 
0