Re: E-mailing Queries

["Brad Stone" <brad@xxxxxxxxxxxx>]

You can use the CPYTOIMPF command.

Sorry I missed the original thread, but I do have very
inexpensive software that can email spooled files.  Check
out SPLTOOL and MAILTOOL at www.bvstools.com, and feel free
to contact me with any questions.  

Brad
www.bvstools.com

On Wed, 1 Mar 2006 13:30:10 -0500
 "John Candidi" <jacandidi@xxxxxxxxxxxxxxxxxxxx> wrote:
> Following someone's suggestion I created a PF and copied
> a spooled file to
> it. How do I get that to the IFS? As you can tell, I'm
> new at this
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Rich Duzenbury
> Sent: Wednesday, March 01, 2006 11:40 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: E-mailing Queries
> 
> On Wed, 2006-03-01 at 09:41 -0500, John Candidi wrote:
> > We have a large number of month-end reports that are
> produced by queries
> > which are printed and distributed each month. Is there
> a way to have these
> > e-mailed directly to the recipients without purchasing
> any additional
> > software? If software is necessary, is there anything
> that will do the
> trick
> > cheaply? Please be as detailed as time allows 
> > 
> There are lots of ways to do this.  There is an open
> source SNDEMAIL
> command, check the archives for the exact location, I
> can't remember it
> offhand.
> 
> Consider sending a link to the report, rather than the
> report itself,
> especially if the report and number of recipients is
> large.  There are
> some nice advantages to sending links, mainly the mail
> server has less
> chance of being overloaded, and the web logs will show
> which reports are
> actually being looked at, and which are not.  
> 
> Store the reports on the IFS, and then make the report
> accessible via
> your iSeries web server.  Converting SCS spooled files to
> IFS files
> could be as simple as a CPYSPLF command, followed by a
> CPY command.
> 
> Access control to the report files could be handled by
> Apache basic
> authentication, or by an RPG/CGI program of your own
> devising.
> 
> Barebones, indeed, but effective, simple, and cheap.
> 
> Regards,
> Rich
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 
> -- 
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 

Bradley V. Stone
BVS.Tools
www.bvstools.com