Re: Attaching Spooled Files to Email

[Martin Rowe <martin@xxxxxxxxxx>]

On Wednesday 05 March 2003 5:33 pm, Tammy Ayala wrote:
> > We are an AS400 shop and would like to distribute reports generated
> > on the AS400 to managers via email.  The issue we are having is that
> > when we copy a spooled file to a text file, the page breaks are lost.
> >  This is not really an issue if the text file is being viewed online,
> > but if the manager chooses to print the file out, it doesn't print
> > properly because of page breaks.
> > Are there any midrange clients distributing reports from their AS400
> > via email?  If so, do you have any suggestions that might possibily
> > help us with this issue?  Are there any utilities that you might
> > recommend to help?  Thanks in advance for any input you might have.
> >
> > Tammy Ayala
> > Valley Health System
> > (909)652-2811 Ext. 5963

Hi Tammy

Assuming these are standard *SCS type spool files, you could do your 
CPYSPLF with the print control characters included, then read the file 
and create your text file with the spacing put back in, including page 
breaks. My WRKUSROUTQ utility uses this method to create text files, 
which you could look at to give you some ideas. 
http://www.dbg400.net/usroutq.html has details on the utility and a link 
to download the source code.

Regards, Martin
-- 
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net   /"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open    \ /
Source free test environment tools and others (file/spool/misc)     X
Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news  / \