Jeffrey M Carey wrote:

>Does anyone have experience with Monarch?  We are trying to use it to
>read AS/400 spool files into comma delimited or spreadsheet files.  So
>far, we haven't had much luck.  Any insight would be great!

We've used Monarch, although not much these days (now that file transfer
works reasonably well).

It parses a spool file: you tell it what's a header, what's footer, how to
identify a data record, where the fields are, etc. etc.  and it translates
your spool file into a spreadsheet.

It works, but takes a lot of work set up each spool file.  However, if you
can't get a disk version of your report, this is the next best thing.
Saves a LOT of re-keying!

We currently have one user who's using Monarch.  We get the data to him as
follows:  We do a CPYSPLF to a data base file.  Then, CPYTOPCD, copying the
file to his personal Office/400 folder.  This folder is visible as an I:
drive from his PC.  The user then does a copy on his PC to move the file to
his hard drive.  And then he can run Monarch.

If we had a few extra minutes, it wouldn't take all that long to create a
data base file in addition to the spool file, so we could download exactly
what he needs, and bypass Monarch entirely.  *sigh*

--Paul E Musselman

| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "".
| To unsubscribe from this list send email to
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator:

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].