Re: E-mailing Queries

["Ron Adams" <rondadams@xxxxxxxxx>]

I use Brad Stone's SPLTOOL utilities http://bvstools.com/ to send reports
via email. This is a great product at a great price, and his support is
outstanding.

But, I've also begun doing a lot of PF dumps for users who want various
reports to be able to load into Excel.

Here's what I'm doing:
1. Send the query output to a temp library that gets cleared weekly
2. Use CRTCSVF http://homepage1.nifty.com/uzaemon/ (works better and faster
than CPYTOIMPF and has options for headers) to dump the PF to a CSV in the
IFS (love all the abreviations)
3. FTP the CSV file to the remote location (usually file server)