Re:

["Qin Huang" <Qin_Huang@xxxxxxxxxxxxx>]

good point, I used cpysplf also. However sometimes I would like to get it in
EXCEL file, because if it's a report I would like to get the colomns seperated.
How to make this possible?

regards
hqin




owner-rpg400-l@midrange.com on 2000-05-05 17:03:04

Please respond to RPG400-L@midrange.com

To:   rpg400-l@midrange.com
cc:
Subject:



An easier way to convert a spool file to a .TXT file which may or may not
be appropriate in  the present instance is to first convert the spool file
to a database file with the CPYSPLF command. This file  can then be
converted to a .TXT file, that can be viewed with something like Notepad,
using the CPYTOPCD command.

Robert Ilechuku



(Embedded image moved to file: pic21693.pcx)

[midrange.com]:RPG400-L@GWCBS
04/05/2000 23:40


To:
cc:
Subject:  Re: Spool file to stream file


Hmmm.. I havent looked at Brad's program to duplicate a spool file,
but I think that what you probably want to use is the "Open Spooled File"
API (QSPOPNSP) and the "Get Spooled File Data" API (QSPGETSP)

You might also find it useful to transform that data into ASCII data,
possibly in some specific printer language (PCL or Postscript?) by
calling the Host Print Transform API (QwpzHostPrintTransform)

All of these are documented in the OS/400 Print API's manual... you
can view it online here:

http://publib.boulder.ibm.com:80/cgi-bin/bookmgr/BOOKS/QBJAMZ00/CCONTENTS

Good Luck!


On Thu, 4 May 2000, Kevin Blankenship wrote:

>  What I am trying to do is take a spool file and make
> it a stream file, So I can attatch it to the sndemail
> program.
> I intend on changing the send email program so it will
> take spool file attributes then call a procedure that
> will convert the spool file to a tream file with a
> ".txt" ending so I can email these reports out.
> I have figured out how to write to the stream file,
> what I havent figured out is how to get the data from
> the spool file.
>  I have looked at Brad's program that duplicates a
> spool file, and was condsidering that maybe I should
> use that method and retreive the data from the user
> space to write to the stream file.
>  Is that the right track or am I wandering down the
> wrong path?
> Also if anyone has an example of how to do this I
> would much appreciate seeing that. :>
>
> -Kevin Blankenship
> AS/400 Gun for Hire
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>
>

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




(See attached file: pic21693.pcx)
(See attached file: Mime.822)
(See attached file: pic21693.pcx)
(See attached file: Mime.822)

pic21693.pcx

Mime.822