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?
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