RE: Summary Output with STRQMQRY -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Greg

I heartily recommend looking at Chapter 12 of the Query Management Programming manual - that is the place that documents how QRYDEF's are used in QM - Query Management.

Having said that, there are things you can do with QMFORM's - but you probably want to use a GROUP BY, as some have said, to get a single summary record. QMFORM's also have a bunch of summary settings - interesting possibilities exist.

I once thought I'd seen what one could do with QM stuff - might be the Query Manager User's Guide, not sure. Both are available at InfoCenter, under Database, under manuals or some such.

HTH
Vern

At 09:55 AM 10/2/2007, you wrote:

Thanks Jim.

Actually, I'm fairly competent with SQL already. I use a good bit of
embedded SQL in RPG and use it a lot on the PC as well. Even made a few
stored procedures on the iSeries and called them from C# programs on the
PC.

We don't write a whole lot of new QRY/400 queries as a rule anymore, but
occasionally we need a quick and dirty printed report for which we don't
want to take the time to write a program.

I'll have to take a closer look at QMQRY. More tools in the old utility
belt the better.

G

This mailing list archive is Copyright 1997-2024 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.