Output from QM query

[Guest.Visitor]

I have 2 questions regarding an output from QM Query. 1st one is when I print out a report from QM, QM always separate 1 query output into pieces of spooled files by the width of 80. Is there a way to control this?? I like what they are doing, but I want to put more data in 1 spooled file. (like if they separate by 132 or more would make it easier for me to see the data.) 2nd one isIs there a way to combine more than 2 spooled files into 1 spooled file? I could copy the contents of spooled file into a database file then run a query/400, but this way I lose page break and everything will be just combined. I want to keep the page brakes, so that a report looks much better. 2nd question is related to the 1st one. I would appreciate it! Noriaki.

[Guest.Visitor]

Nori, To answer Q1. There are at least 2 possibilities. <pre>CHGPRTF QPQXPRTF PAGESIZE(*SAME 196) CPI(15)</pre>This goes further than you probably need, it changes it to 196 instead of 80, but you can make it 132 (if you make it 132, the CPI parameter would most likely be unnecessary). <pre>OVRPRTF FILE(QPQXPRTF) PAGESIZE(*N 196) CPI(15)</pre>Unlike the first example, this is a temporary change, the previous is a permanent change (unless the OVRPRTF is issued). Bill Nori wrote: I have 2 questions regarding an output from QM Query. 1st one is when I print out a report from QM, QM always separate 1 query output into pieces of spooled files by the width of 80. Is there a way to control this?? I like what they are doing, but I want to put more data in 1 spooled file. (like if they separate by 132 or more would make it easier for me to see the data.)