Re: Strange issue using QMQRY. -- MIDRANGE-L

Subject: Re: Strange issue using QMQRY.
From: Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Date: Wed, 20 Apr 2022 11:29:59 -0400 (EDT)
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

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.

Follow-Ups:

Re: Strange issue using QMQRY. , a4g atl

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.