RE: spool files - how to select for email

<<We use these techniques heavily in our Email Report Server and Report
Splitter products.>>

Excellent products, both. Many of my clients have used these successfully
for years.

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Schoen
Sent: Tuesday, April 24, 2012 9:34 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: spool files - how to select for email

Unique report names or if each report gets generated individually process
them inline.

The other option would be to place email criteria in the user defined data
fields when generating the reports then extract the data from the user
defined data.

We use these techniques heavily in our Email Report Server and Report
Splitter products.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

------------------------------

message: 4
date: Tue, 24 Apr 2012 14:14:32 +0000
from: "Stone, Joel" <Joel.Stone@xxxxxxxxxx>
subject: spool files - how to select for email

BIGJOB creates 3 different spool files with the same name - CUSTRPT. Today
the spool file numbers happen to be #'s 65,66, and 67.

In my email pgm, I can only select *LAST (which would only send report #
67), or I can select a specific #, such as 65 or 66 or 67. But I don't know
the number.

What is the best way to handle this?

Name each spool file differently? Then I can name the three files CUSTRPT1,
CUSTRPT2, and CUSTRPT3, and select each one.

Or, is there a way to retrieve the *LAST spool file number, and the (*LAST
minus 1) spool file, and (*LAST minus 2) spool file?

Or a better method?

I see an API coming my way. Is there a SIMPLE way to do this - ie not
using an API?

For example, RTVSPLFA (*LAST minus 2) ?? I have TAATOOLS if that helps.

Thanks