Don't use any ourselves, but there are ads in the various magazines / e-zines for products that do this.

My users generally ask "can we get this in a CSV" instead of, or in addition to, the printed report. We just rework the program to do different output. I tend to write the CSV directly, but I suppose you could write to a temporary table and use CPYTOIMPF.

Thanks Dale, when you say you write to the CSV directly, how do you do that?

Jeff, the cvtToCsv procedures in RPG xTools will allow you to write directly to a CSV file. Those subprocedures are:

• openCSV
• writeCSV
• closeCSV

Bob, we don't have RPG xTools at our location.  What does that cost?

Yes write into temporary file and using CPYTOIMPF place the CSV file into IFS folder. Then map the drive into local drive. So user can access the local drive and take the csv file.

Thanks

Senthil A