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.

==================================
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 ...
  
  To continue reading for free, register below or login

  Requires Membership to View

  To gain access to this and all member only content, please provide the following information:

  Email Address:
  
  
  

  By joining Search400.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.
  
  TechTarget cares about your privacy. Read our Privacy Policy
  To read more you must become a member of Search400.com

  As an existing member of the TechTarget network please activate your Search400.com account 

  By joining Search400.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.
  
  TechTarget cares about your privacy. Read our Privacy Policy
  
  
  

  Digg This!     StumbleUpon     Del.icio.us

  
  
  
  

  RELATED CONTENT iSeries programmer tips Enhancing RPG with external SQL stored procedures Tracking data changes on IBM i with triggers Introduction to SQLRPGLE on IBM i: Making a report Implementing a browser interface in COBOL: Displaying database fields Taking advantage of CL advancements, starting with V5R3 TAATOOL: Useful tools for programmers on IBM i Implementing a browser interface in COBOL: Creating your graphic Web page Implementing a browser interface in COBOL: Getting started Making the most of RPG data handling on IBM i Groovy programming on IBM i Application Development iSeries calling an .exe Top 10 programmer tips Formatted work job scheduler Convert system date and time Mixing free format code with embedded SQL SQL update a field in one file from a field in another file Webcasts for iSeries programmers Programming advice from the pros Easy code copying via the drag and drop method Setting FTP time-outs iSeries CL programming Taking advantage of CL advancements, starting with V5R3 Checking in on your IBM i authorization lists Running PHP open source applications: NOBODY needs authority Simplify the process of converting a spool file from iSeries into an Excel spreadsheet CL program for daily backups An automated CL method of moving a query from AS/400 to Excel Changing user password expiration Eight steps for creating program documentation using AS/400 utilities DAYSPAST CLLE program for AS/400: Compares object creation date with today's date Advanced Job Scheduler help

  RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

  
  
  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.