AS400 query print landscape/legal?
Home > IT Answers > AS/400 > AS400 query print landscape/legal?
Lilarose
70 pts.
0
Q:
AS400 query print landscape/legal?
AS/400, AS/400 Query, AS/400 printing
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: Sep 24 2009  4:35 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
CharlieBrowne
6540 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Sep 24 2009  5:49 PM GMT by CharlieBrowne   6540 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Lilarose   70 pts.  |   Sep 24 2009  5:54PM GMT

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.

 

CharlieBrowne   6540 pts.  |   Sep 24 2009  6:51PM GMT

If you are doing a RUNQRY command, you can prompt on that and set your Printer file specs

 

Lilarose   70 pts.  |   Sep 25 2009  2:47PM GMT

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.

 

KasMcc   120 pts.  |   Oct 13 2009  3:24PM GMT

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

 
0