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

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)