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.