Re: Strange issue using QMQRY.

The queries are normal queries that were converted from QRY/400.
I am using the OVRPRTF QPQXPRTF command to redirect the output to specific
printers. Actually a bit more. I update the USRDTA, SPLFNAME,
OVRSCOPE(*JOB).
The rest should run as per a normal QRY/400, you would think.
Darryl.

On Wed, Apr 20, 2022 at 11:30 AM Vern Hamberg via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Darryl

Welcome to a better albeit different world!

How wide is you report? And how wide is QPQXPRTF? In QM, if the report is
wider than the PRTF, the overflow goes into additional SPLFs, while Query
for i typically truncates.

You will need to OVRPRTF QPQXPRTF with more columns, if this is the
situation, before running the QM query.

Regards
Vern

----- Original Message -----
From: "a4g atl" <a4ginatl2@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxxxxxxxx

Sent: Wednesday, April 20, 2022 10:23:54 AM
Subject: Strange issue using QMQRY.

I have been changing/converting QRY/400 or *QRYDFN to Query Manager
Queries. The process is simple.

The strange problem I am experiencing now is STRQMQRY is producing 2 spool
files for each time a query is run.

The printer file is QPQXPRTF.

Does anyone know why this is happening?

TIA, Darryl Freinkel.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com