Re: help with CCSID - how to ensure a file can be successfully sent to root directory using CPYTOIMPF

On Thu, Mar 29, 2012 at 8:15 AM, <rob@xxxxxxxxx> wrote:

May take a little more initial set up but for a faster, more
reliable, more granular (thus easier to trap exceptions)
solution you may wish to look at rolling your own with:
http://www.scottklement.com/rpg/ifs.html

For that matter, since the OP's ultimate goal is for the data to be
read by Excel, another choice would be to go whole hog and use Scott's
POI-wrapping stuff to generate the Excel file directly.

There are other Excel options, including third-party wrappers to
Scott's POI wrapper, such as

http://www.easy400.net/hssfcgi/html/page1.htm

And, of course, there is my favorite: iSeries Python and the
third-party xlwt package. (In my opinion, this is much easier to set
up from scratch and use than any RPG/Java solution, plus you then have
Python, which is a worthy addition to any IT tool set.)

John