removing blank page in a spooled report

85 pts.
Tags:
Spool files
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check the definition of the outq and make sure that the “Print separator page” option is set to “*NO”.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Sherryborden
    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
    85 pointsBadges:
    report
  • Sherryborden
    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
    85 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Teandy
    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.
    5,860 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following