Home > Ask the AS/400 Experts > iSeries i5/OS and OS/400 Questions & Answers > Copy a spoolfile (report) into the IFS as a .txt file
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Copy a spoolfile (report) into the IFS as a .txt file

Ken Graap EXPERT RESPONSE FROM: Ken Graap

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 07 December 2004
I have copied a spoolfile to my PC manually using iSeries Navigator. And I've copied a database file to the IFS using the CPYTOIMPF command. So I suspect there must be a way to get the spoolfile to the IFS -- either manually or a command.

When I try to drag it from the basic operations, printer output, it will not work. Is this a security issue? I looked for a command but did not find one.

>
You kind of answered your own question ... You can copy a spool file to a stream file but you have to move it to a DB file first!

Here's how I'd do it:

First create a database file like:

  CRTPF FILE(QTEMP/DBfile) RCDLEN(132)

Next copy the spool file into that database file:

 
        CPYSPLF FILE(MySpoolFile) TOFILE(QTEMP/DBfile)

Now that you have a database file, it is easily moved into the IFS like this:

 
         CPYTOIMPF FROMFILE(QTEMP/DBfile) 
            TOSTMF('/home/keg/MySpoolFile.txt') 
            STMFCODPAG(*STDASCII) RCDDLM(*CRLF) 
            DTAFMT(*FIXED)   

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Ask your OS/400 questions -- or help out your peers by answering them -- in our live OS/400 discussion forums.

Ask the Experts yourself: Our OS/400 gurus are waiting to answer your questions.

Check out this Search400.com Featured Topic: 20 ways to ensure a smooth OS upgrade


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
iSeries i5/OS and OS/400
Will overloaded discs impact iSeries performance?
Error CWBCO1049 on AS/400
Recovering from DST QSECOFR password disablement on V5R4
Enrolling a user profile in the i5/OS system distribution directory
How to resolve a CPI93B8 error message: LIC problem data has been logged for #MSTRTNS
Checking if a local port is used by another job on AS/400
Restricting specific user command line access
Print private authorities (PRTPVTAUT) command for user objects in a library with *public exclude
Getting modules to adopt authorities from the main program
Copying a physical file back to a spool file

Documentation
How database views get deleted from AS/400 libraries
Print private authorities (PRTPVTAUT) command for user objects in a library with *public exclude
iSeries i5/OS: Top 10 Q&As
iSeries i5/OS: Top 10 Q&As
New, undocumented Query function can boost your productivity
New option within the WRKSYSACT command
See the users with *change or *all authority
If at first you don't succeed, read the documentation
Limit command line access
Upgrade from V5R1 to V5R3 and license validation

Past Releases
iSeries i5/OS: Top 10 Q&As
iSeries i5/OS: Top 10 Q&As
Error message within the printer file
How often are message queues cleared?
Connect the dots: Get your iSeries servers talking to one another
Embedding SQL into RPG LE programs
In search of a table that shows system & O/S release compatibility
V5R3 view disk IOA cache battery expiration
New option within the WRKSYSACT command
See the users with *change or *all authority

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
AS/400  (Search400.com)
i5/OS  (Search400.com)
iSeries  (Search400.com)
OS/400  (Search400.com)

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



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts