AS400 query print landscape/legal?

75 pts.
Tags:
AS/400
AS/400 printing
AS/400 Query
How do you get Query to print in landscape on legal sized paper? I tried adjusting the paper size but that didn't seem to help.

Software/Hardware used:
AS400
ASKED: September 24, 2009  4:35 PM
UPDATED: March 15, 2012  2:07 AM

Answer Wiki

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

You can create a PRTF with all the specifications for your output: OUTQ, FONT, #characters per line, etc.
Then change your QRYDFN to use that file or do an OVRPRTF before you run your query.
Or you can change the Form Size in the Query, to the width you need.

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
  • Lilarose
    Thanks, but the query is going to be run interactively over existing files, so I won't have any input into the file format the query runs over. I did try the form size option, but it still wouldn't go landscape on legal.
    75 pointsBadges:
    report
  • CharlieBrowne
    If you are doing a RUNQRY command, you can prompt on that and set your Printer file specs
    39,815 pointsBadges:
    report
  • Lilarose
    The runqry command has the same options as the Query itself, so there was no way to indicate legal size paper to print on. I found a work-around by sending it to the spoolfile, and from there to set the drawer # on the printer. That forced it to go to legal size paper when printing. It's not pretty but it got the job done. Thanks for the help.
    75 pointsBadges:
    report
  • KasMcc
    If I need to print a query on different size paper, I put the query into a CL program and include the page layout in the program E.g. PGM
    /* MONITOR FOR ALL ERRORS */
                 MONMSG     MSGID(CPF0000)
    
    /* SUBMIT QRYS TO PRINT Plan Volume Report */
                 OVRPRTF    FILE(QPQUPRFIL) PAGESIZE(70 150) CPI(13.3) +
                              OVRFLW(69) OUTQ(QUSRSYS/PRT01) FORMTYPE(*STD) +
                              HOLD(*NO) SAVE(*YES) USRDTA(AUTUMN)
    
                 RUNQRY     QRY(QRYPROGS/DAY36A)
    
                 DLTOVR     FILE(*ALL)
    
    ENDPGM                     
    Hope this helps
    230 pointsBadges:
    report
  • Kathyink
    If I had found this earlier I would not have dried up my ink cartridges running test after test to try and do it right. Thank you for the information, you saved my day.
    70 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