RE: A quick question on spool files

["Cox, Joe" <joecox@xxxxxxxxxxx>]

Another down and dirty way, assuming the report is one line per record, is
to using Operations Navigator, drag the spool file to a desktop creating a
text file.  Open it with a spread sheet parsing the fields of interest.
Remove the printer heading lines, do any other work that spreadsheets are
good at and save as a .dif file.  Transfer it back to the AS/400 with Client
Access and you can then query it, link to other files, etc.

You could automate most everything here but I doubt it would be very robust.

Joe Cox
Bozeman, MT

        -----Original Message-----
        From:   Buck Calabro [SMTP:buck.calabro@aptissoftware.com]
        Sent:   Thursday, August 03, 2000 7:39 AM
        To:     MIDRANGE-L@midrange.com
        Subject:        RE: A quick question on spool files

        Paudie O'Riordan wrote:

        >Is it possible to change spool files into 
        >Database members/files for query
        >purposes and how do you do it?

        Using what comes with the box you can CPYSPLF a spooled file to a
"flat"
        file, but querying that will be... unpleasant.  Depending on what
your
        business needs are, you may want to look at a product like Monarch
which
        extracts the data out of the columns and creates a PC spreadsheet
out of it.

        Buck Calabro
        Aptis; Albany, NY
        "We are what we repeatedly do.
         Excellence, then, is not an act, but a habit." --Aristotle


        Billing Concepts Corp., a NASDAQ Listed Company, Symbol: BILL
        +---
        | 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
        +---
+---
| 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
+---