Home > IT Answers > AS/400 > How to automate getting the .CSV file from IF...
Richapd
5 pts.
0
Q:
How to automate getting the .CSV file from IFS folder to local desktop
IFS Folder, RPG/400, RPGLE, CSV format, AS/400 import/export
I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system.

Is there any way to open the .CSV files stored in IFS folder?
ASKED: Apr 8 2009  6:15 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Teandy
2860 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I'm not sure I understand what you are asking. Are you asking how to open the file or how to get the file to the local PC?

You can open the file on the IFS with Note pad, Word pad or Excel. If you are looking for how to get the file from the IFS to the local PC, you might want to start with Scott Klement’s tutorial "Working with the IFS in RPG IV" which you can find at http://www.scottklement.com/rpg/ifs_ebook/
Last Answered: Apr 13 2009  2:55 PM GMT by Teandy   2860 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



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

RVP400   230 pts.  |   Apr 14 2009  4:26PM GMT

Richapd,

One way to automate the transfer is using a FTP script to transfer the file from the IFS to a PC. You can have the script on the ISeries and run it directly from your program or have it on the PC and use the STRPCCMD to invoke the script.

If this is what you need, let me now - I can provide extra details on how to do it.

RVP400

 
0