removing blank page in a spooled report
I have written an SQL script that validates various tables. This script produces a different report for each table. Only if there's an error on a table do I want that particular report to print. Different people are responsible for the diffent tables so I need to do a page break between the reports. I have this working. MY PROBLEM IS A BLANK PAGE IS PRINTED FIRST & then any of the other reports that have errors. How do I prevent the blank page from printing OR how do I force just a header onto the blank page? We use E-PRINT and it's skipping the first report.All help is greatly appreciated.Sherry
Software/Hardware used:
Software/Hardware used:
ASKED:
January 22, 2010 3:59 PM
UPDATED:
February 1, 2010 5:51 PM
Answer Wiki:
Check the definition of the outq and make sure that the "Print separator page" option is set to "*NO".
To see all answers submitted to the Answer Wiki: View Answer History.
This is under the AS400 topic, so I’d assume this is related to AS/400s. What is E-PRINT? Google didn’t list anything useful for AS/400s in the first couple dozen hits. And how are your SQL “scripts” being executed?
Tom
Teandy,
i wasn’t able to get back here until today. I don’t understand what it is I’m to check.. sorry. What is the ‘OUTQ’ and where would I see ‘Print Separator page’? Is this part of E-Print or is it something I should have in my script?
Sherry
TomLiotta,
I’m new to the ‘world’ so I’m not sure how I managed to get my question posted to AS400 because it’s not. We’re Windows & Linx ..
Sherry
Sherry:
That’s okay; I wanted it mentioned in case it was inadvertent. I see you opened a new question, so I’ll just say a couple things.
In the other question, be sure to mention E-PRINT. Also, “SQL scripts” may be supplied in a whole bunch of ways. Be sure to describe how the scripts are submitted for execution.
Also, if you can determine this, say whether or not each script actually results in an individual spooled file and they all simply print one after the other, or if all scripts are spooled to a single report that you have to separate manually. This could be determined by watching the spooler in Windows. (I can’t say much about Linux unless you happen to be running one of the couple that I happen to have access to.)
Tom
Are you printing these reports off of your iSeries or are you pulling the information down to an excel sheet and printing it from there?
If you are printing from the iSeries, then you are using an outq. Part of the definition of the outq says whether or not to print a separator page when the report starts.
If you are pulling the information down to an excel sheet, then the problem is somewhere else.