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.

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.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].