from AS400 to an ascii text file on my PC

[Patrick Oosterholt- Allers Bedrijfswagens B.V.]

Greetings,

I need some help with the following:

I have some output in my spool file. But I don't want to send it to a
printer but I want it to become an ASCII text file which I can download and
use on my PC (Windows OS).

How do I do this?

I'm not an AS400 expert but I know this can be done. I just need to know
what command's I need to use...

Thanks

Patrick Oosterholt
P.Oost...@allers.nl

[Larry W Loen]

As far as I know, there's still no direct interface to let you
FTP a spool file to a PC. The method I use is to create
a regular AS/400 file, copy the spool file to some member
in this file, and then upload the file-and-member to my PC.

Something like:

CRTPF FILE(MYLIB/MYPRINT) RCDLEN(133)
MAXMBRS(*NOMAX) SIZE(*NOMAX)

then, once I have the spool file of interest:

CPYSPLF FILE(QSYSPRT) TOFILE(MYLIB/MYFILE)
JOB(00nnnn/USERID/QPADEV00nn) SPLNBR(nnn) TOMBR(MYNAME)
MBROPT(*REPLACE)

Be sure to replace the various "nn" with the correct values. A spool file is
known by its job number, the user profile, and the third parameter is usualy
something like the 5250 session that the job was executing under. The SPLNBR
is there because some jobs have more than one version of a file, especially
QSYSPRT which is where things like stdout in C or many regular AS/400 commands
end up.

Then, just use FTP to upload MYLIB/MYFILE MYNAME to something meaningful on
the PC.

Check around. A lot of people provide a variety of front-ends to this
process. The guy next
door may have a nifty little utility that makes all this easy.

[Jörn Knust]

An other way is to define the Generic Printer under Windows with
Connection FILE:
then you con define an Printer Emulation for the Windows Printer.
Every time you start to print, you are ask where to save the ASCII
File.
This way is mor complicated for one Spool File but less to do to save
many Files.

[Peter]

a simple but effective solution is to have an lpd-queue on your
windows-system, like mocha-lpd (www.mochasoft.dk).
You then define an outqueue on as400, which points to the ip-adres/queue of
your pc and which uses a plain-text printerdriver and host print-transform
(ebcdic->ascii).
Al you do next to have the spool on your pc is print the output to the
outqueue. It is then automatically send as plain ascii to your pc.
I use a setup like this all the time, and it saves me a lot of paper.

Patrick Oosterholt- Allers Bedrijfswagens B.V. <P.Oost...@allers.nl>

schreef in berichtnieuws 94103633...@WHIRLwind.plex.nl...

[Marlon Wade]

If you are using operations navigator just drag the spooled file to your
desktop or a folder on your client, this will convert the as400 report to an
pc text file.

[Bradley V. Stone]

www.bvstools.com/spltool.html

SPLTOOL will let you download a spooled file via FTP, shared folders or
the IFS to text, doc, excel, or html.

--
Bradley V. Stone
BVS/Tools
http://www.bvstools.com
(posting via DN because my ISP can't run a newserver)

Sent via Deja.com http://www.deja.com/
Before you buy.

[Richard Schoen]

Check out WinSpool/400. WinSpool/400 is a Windows based tool for downloading
AS/400 reports to the PC in various formats such as ASCII, MS Excel, PDF,
RTF, HTML, etc....

Here's the web site address: http://www.rjssoft.com

Regards,
Richard Schoen
RJS Software Systems

Patrick Oosterholt- Allers Bedrijfswagens B.V. wrote in message
<94103633...@WHIRLwind.plex.nl>...

[dian...@my-deja.com]

You'll want to look at Symtrax's award winning
and critically acclaimed software called
Compleo. It lets users easily download spool
files from the AS/400 into PC applications like
Excel, Word, html, etc..., email and archive
too. Evaluate the software for 30-days at
http://www.symtrax.com (in the Americas and Asia)
or http://www.eu-symtrax.com (in Europe).

Best regards,

Diana Bao
Symtrax

In article <94103633...@WHIRLwind.plex.nl>,
"Patrick Oosterholt- Allers Bedrijfswagens

B.V." <P.Oost...@allers.nl> wrote:
> Greetings,
>
> I need some help with the following:
>
> I have some output in my spool file. But I
don't want to send it to a
> printer but I want it to become an ASCII text
file which I can download and
> use on my PC (Windows OS).
>
> How do I do this?
>
> I'm not an AS400 expert but I know this can be
done. I just need to know
> what command's I need to use...
>
> Thanks
>
> Patrick Oosterholt
> P.Oost...@allers.nl
>
>

Sent via Deja.com http://www.deja.com/
Before you buy.

[Itpro99]

I beleive you can do "savsplfil" then you can save it as an ASCII text file for
downloading. You'll have to specify which lib as well as the file name. If
this doesn't work you can do a dsp sav* on the command line and it will pull up
all your "save" commands. Hope this helps..

Brian Dinter

[AB]

No what you really do in a CPYSPLF to a file that you have created in your
library with 132 record length, then pc transfer this down as .txt or
whatever !!!

Andy
Itpro99 wrote in message <19991114115737...@ng-fu1.aol.com>...