RE: Need a COMPARE utility and spool saver

["Harrell, Michael E" <michael.harrell@xxxxxxx>]

Hello Dan,

You asked for a way to save spool files to a PC so that you could view the
files without the 400.  We did this for one of our customers who was being
audited for the IRS.  The IRS requested Trial Balances saved in a PC format
so they could download the files into some type of PC auditing package they
use.  I do not know how they got them off and have not had to do it myself,
but here is how we converted the 400 spool files into PC files.

Hope this helps.

Mike Harrell
Information Analyst
EDS TSC-North


Creating PC formatted (ASCII) files from a Spool File:

1.  The spool file must be on hold on the print queue.
        Option #8 to view the attributes of the SPLF.
        Note the File Name, Job Name, User, Job Number, and Spooled File
Number.

2.  Create a physical file to save the SPLF into:
        CRTPF   F4
        Name the PF.
        Library = EDSWORK  (Create this library if it's not there yet.)
Record Length = 133  (To make room for a 132 column report format.)
        Make sure that the Maximum # of Records is *NOMAX

3.  Create a folder to hold the PC formatted files:
        CRTFLR  F4
        Enter a description.
        F10     Authority = *Change  (To allow all users access to the
folder.)

4.  Copy the SPLF into the created PF, with CPYSPLF.
        Enter the SPLF Name.
        DBFile = the created PF
        Library = EDSWORK
        Job Name = 
        User = 
        Number = 
        Spooled File Number = 

5.  Convert the PF records to the PC (ASCII) format and copy to the created
folder: 
        CPYTOPCD                F4
        From file = Created PF
        Library = EDSWORK
        To Folder = Created folder
        To Document = Enter the name you want for the ASCII file
        Replace = *YES

6.  Clear the created PF after each copy so it is empty for the next copy:
        CLRPFM EDSWORK/Created folder Name


If a mistake is made when naming the ASCII file, WRKFLR, page down to find
the folder, Option #5 to view the documents, #7 to rename, #8 to change the
description.

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---