Q
Problem solve Get help with specific problems with your technologies, process and projects.

Convert a file to .CSV format

My users have a menu option to build a data file on the iSeries via a submitted job. Is there a CLP method of downloading the file to an excel spreadsheet in that same batch job? We use Client Access for the transfers.
There are multiple methods you can use to convert the file to .CSV format, including the CPYTOIMPF. The CPYTOIMPF will convert it to a flat-file in CSV format. The option to do this would be to use *DLM for the DTAFMT keyword. The user would then need to execute the file-transfer request. Another option would be to use the CPYTOIMPF to convert it to a file in the IFS where the user could then use a mapped drive to copy/open the file in Excel. There are also a number of utilities that will do this.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Ask your OS/400 questions--or help out your peers by answering them--in our live OS/400 discussion forums.

OS/400 Discussion Forum: Post your questions, and get answers from other iSeries users as well as search400 experts.


This was last published in January 2003

Dig Deeper on Past Releases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close