Copy Pf data into .csv file
Last Post 05 Feb 2013 02:52 PM by Lynne Noll. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
imrkhan
New Member
New Member
Posts:11

--
05 Feb 2013 11:12 AM

I am a newbie to As400. Can you please explain me the steps to transfer data from a physical file to .CSV file to pc.?


Thanks in Advance




Lynne Noll
Senior Member
Senior Member
Posts:6567

--
05 Feb 2013 02:52 PM
Try the CPYTOIMPF command to put it in the IFS. You can FTP it from there, or map a windows drive to the IFS directory, or get it with Navigator.
You only have to supply the FROMCCSID if the data base file does not have a real ccsid; 37 is US EBCDIC. The default is CSV; you can use a different delimiter.




CPYTOIMPF FROMFILE(UPLOAD15) TOSTMF('/reports/lnoll/upload15.txt') MBROPT(*ADD) FROMCCSID(37)
STMFCCSID(*PCASCII) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING)

You are not authorized to post a reply.

Acceptable Use Policy