Copy spool files to a PC text file

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:
- Start
- Programs
- 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.


  • 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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.