Re: QMQUERY question

Darryl

Take a look at the manual at https://www.ibm.com/docs/en/ssw_ibm_i_71/books/sc415703.pdf, esp. chapters 11 and 12, which have a lot to say about how Query 400 queries are converted. Most, if not all, of your questions should be answered. Summary reports don't convert directly very well, as I recall - the OLAP functions could be used as the SELECT in the resulting QMQRY source.

Also, when you do the RTVQMQRY for one of those that have summary, check the job log for QWM* messages - I think you should see some, especially about extra columns added, or other things.

Regards
Vern

On 4/26/2022 12:29 PM, a4g atl wrote:

Thank you. STRQM made a huge difference.

Now I am working on how to resolve migrating over a summary qry into QMQRY.
It seems it does not do the summary options.


On Tue, Apr 26, 2022 at 12:15 PM Carel via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

STRQM

option 1

With F17 switch between SQL mode or Q400 mode

For new type 1 + name Enter

Create your SQL statement.

Press F6 or F5 to see a result set

F13 to FORM editor


Op 26-4-2022 om 18:06 schreef a4g atl:

How do you get to editor? I cannot find teh command or sequence of steps

to

get to it.

Thanks

On Tue, Apr 26, 2022 at 11:18 AM Carel via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

With F13 you enter the FORM editor.

In the first option of that menu you can add BREAAK levels, editng,,
change column headers.


Op 26-4-2022 om 15:26 schreef a4g atl:

How many people use QMQRY?

I migrated a few *QRYDFN to *QMQRYs but the migration produces

different

results, example, there is no simple way to run a summary query.

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