This may be an old tool for a lot of people, but it is a tool that I just came across. The users in my company are asking for more and more Excel spread sheets from the iSeries database. They also want these spread sheets to be generated automatically and sent via e-mail, or course the first thing in the morning is a must. The PC server, where we have a package that can do this is now over taxed with batch jobs and if one of those jobs fails then every job behind it is backed up.
I searched for a simple solution where I can put some of the processing back on the iSeries and off the server. I came across one and the few test I did is showing promise. This tool will take a SQL SELECT statment and generate an .xls in the IFS folder of you specifcation.
To find out more about this tool read the two articles from Giuseppe Costagliola.
andy's home page
*******latest version as of today http://www.code400.com/downloads/jex..._2_5_8.tar.tar
Let me know is you use this and how is it working for you.
I searched for a simple solution where I can put some of the processing back on the iSeries and off the server. I came across one and the few test I did is showing promise. This tool will take a SQL SELECT statment and generate an .xls in the IFS folder of you specifcation.
To find out more about this tool read the two articles from Giuseppe Costagliola.
andy's home page
*******latest version as of today http://www.code400.com/downloads/jex..._2_5_8.tar.tar
Let me know is you use this and how is it working for you.
Comment