|
On 06/08/2005, at 7:40 AM, Condon, Mike wrote:
No, I'm going to a spool file. Is there an API call to find out the sizeof a spool file?
QUSRSPLA will give you size information (number of pages, number of records, data stream size, file size (and multiplier))
Note that Query will always print a cover page plus 1 data page. If the query retrieved no data then the second page will have text saying "No records in query report." (from QRY1906 in QQRYMSG).
You'd probably be better using the other spooled file APIs to check for this line if the page count is 2 or less.
There doesn't seem to be any way to force this message to the job log when spooling the report.
Regards, Simon Coulter. -------------------------------------------------------------------- FlyByNight Software AS/400 Technical Specialists http://www.flybynight.com.au/ Phone: +61 3 9419 0175 Mobile: +61 0411 091 400 /"\ Fax: +61 3 9419 0175 \ / X ASCII Ribbon campaign against HTML E-Mail / \ --------------------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
