----- Original Message -----
From: "PaulMmn" <PaulMmn@ix.netcom.com>
To: <midrange-l@midrange.com>
Sent: Thursday, January 10, 2002 8:26 PM
Subject: Re: AW: Pulling spool files off AS/400 - VB?

> Adam,
> Oliver's reply made me realize that 'all' you want is a spool
queue downloader.

That's pretty easy to do - you just set the writer on the outq to
lpr to a pc, run lpd on the pc.

I can think offhand if it will use something in particular for the
filename. We wrote out own lpd where you can pass the file name
(and select the subdirectory to write to) with various methods.
there are extra parameter fields, or you can use the printq name
and parse it on the lpd side.

> One product that includes this function is MetaFile.  Part of
> package is a downloader that downloads an output queue to a
> on a PC.  The download can be set to run automatically every xx
> seconds.  The downloaded spool file can be deleted or moved to
> another output queue.

Our LaserVault system does something similar, but we give the user
explicit selection capabilities thru command line or cl on the
host, it seems silly to download something and erase it.

> We have the program running on an NT server.  The only drawback
> the version we have (2-3 years old) is that it does not run as a
> service; you need to keep a session signed on and the program

They might have a newer version that does run as a service, most
of us COLD vendors did that a couple of years ago. If not, tell me
so I can use it against them in competitive situations. That will
ge them to upgrade the product with the feature you want.

> MetaFile is a program which archives spool files, indexes the
> contents, and allows users to find documents based on that
> The archive is created and stored on a PC.  Because the
retrieval is
> an index lookup, not a search, it is quick.  New documents are
> to the index after they are downloaded.  Time to add a document
> the index depends on the size of the document, number of words
> index, and the existing size of the index.
> Every word, character sequence, and number are indexed.  You can
> search for a dollar amount listed at the bottom of an invoice, a
> customer number, a city name, a customer name.  Anything.  You
> also omit 'junk' words (like a, an, the, of, from, etc., etc.)

And there is an example. We have always done our indexing on
selected columns (including keys that are made up of several
different fields). Our indexing is faster than anyones (in
generation, they are all about the same in retrieval speed), but
Metafile honks on the fact we don't do full text indexing (many of
our customers use very large spool files, and full text indexing
isn't that important when you are looking up invoice numbers,
customer names, etc.) So now we are adding full text indexing.

> You can add an overlay and view the archived spool files as if
> were printed on your custom forms.
> I don't know if they offer the download portion separately.

They probably don't. We don't, but if there is a market for this
let me know, it would be easy to abstract it out.

We have another feature that no other COLD vendor has, to my
knowledge - SCSI download. We can imitate a tape drive and get
stuff off the AS/400 faster than any LAN - and without loading up
the LAN. I've often thought it would be great for large data
replication work.

> One thing that impressed us when we invited the MetaFile folks
> give us a demonstration:  IT WORKED!  We provided a PC with
> Access installed (I don't recall if it was an NT machine or not;
> production version is running on NT).  The rep installed the
> on the PC (no software required on the AS/400).  After tweaking
> settings for the output queue to monitor (and, IIRC, tweaking
> authority), IT WORKED!  Took less than 30 minutes from a
> start.  IT WORKED!  As advertised.  No messing with fancy
> No "Oh, you need to do such and such."  IT WORKED!!  That sold
> even though there were other products we had yet to evaluate.
> --Paul E Musselman
> PaulMmn@ix.netcom.nospam.com

Metafile is a good product, one of the best on the AS/400. I
didn't realize they weren't putting software on the AS/400. The
advanatage of having software on the AS/400 is the ability to
control the reports you download, the ability to append and name
them, the ability to control the PC side from the AS/400 side and
report back errors to the operator, and the ability to print back
to the AS/400.

We've got a programmable LPD (Line Printer Daemon) which we do not
yet sell as a product. But for example, we are working on a
combination of our LPD and our Nextract data extract (if you have
used Monarch to convert reports to spreadsheets or databases, it's
similar to that but lots better). The idea is you take a report
and download it, convert it to a spreadsheet or database, and
email it, all in one function from the AS/400 side.

I've also thought of print to LPD, and include instructions to run
x program on the file, or just email it.

Brad Jensen
LaserVault - you might like it even better than Metafile, or maybe

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 by midrange.com 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.