Simplify the process of converting a spool file from iSeries into an Excel spreadsheet

Simplify the process of converting a spool file from iSeries into an Excel spreadsheet

I need to transfer a spool file from the iSeries to the server and convert it to an Excel spreadsheet.

Currently, I copy the spool file to a database file and then implement a file transfer protocol (FTP), relocating the file to the server in .txt format, and then convert this .txt format to Excel. As you can imagine, it's very time consuming. What can I do to simplify this function?

    Requires Free Membership to View

    Login

    Register today to access targeted resources from our editorial writers and independent industry experts including news, tips, and advice to help you do your job more efficiently and effectively. Stay informed on the hottest topics and biggest challenges faced by IT professionals working with iSeries products and services.

    By submitting your registration information to Search400.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of Search400.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Is it possible to just eliminate the creation of the spool file?

The CPYTOIMPF command can be used to create a CSV text file that can be loaded easily into Excel. If the spool file is being generated by a query, the new IBM DB2 Web Query offering supports a spreadsheet output format when running DB2 Web Query reports.

This was first published in March 2009

Back to top