If you'd like to copy spool files to a PC text file (if you have Client Access) there is an alternate option to using the CPYSPLF command and then doing a data transfer from the iSeries.
Follow the instructions below:
1. Open Windows Explorer.
2. Open AS/400 Operations Navigator go to:
- IBM AS/400 Client Access Express.
- iSeries Operations Navigator
3. Click the AS/400 your spool file is on.
4. Click on Basic Operations
5. Click on printer output.
6. In the right screen all your spool files will appear.
7. Click the spool file you wish to copy.
8. Drag the spool file into a folder in your Windows Explorer. And ta-da .. the spool file is copied into a text file, which can also be opened in Excel.
================================== MORE INFORMATION ON THIS TOPIC ==================================
- Make a spool file disappear
A Search400.com member wanted to know if it's possible to make spool files disappear after seven days. Not exactly, according to site expert Ken Graap, but he does offer an alternative method for getting rid of them.
- Use ABTOBJUSR command to eliminate batch job headache
Have you ever submitted a batch job only to find out it has failed because there happened to be a user session accessing the file? This can be quite annoying. Here is a command that site expert Dwight Beech set up that allows you, the developer or administrator, to warn users accessing a file, program, data area, etc. and then end their session if needed.
- Secure printed output
In today's security-conscious environment, most iSeries shops have been busy investing in improved security for their systems. Object-level security is being locked down, and users are being classified as to what they can and cannot do when they are logged on to the system. But securing files is only part of the solution. If a user can't look at a file, but can look at processed output sitting in a print-spool file, then your hard work of locking up the files could be all for nothing.
This was first published in July 2003