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?
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.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading