To add to this - you CAN use STRQMQRY and specify the *QRYDFN as both the query and the form.
Now this will use default handling of things and may not give you what 
you want - summary-only, for example, is just not done this way - you'd 
have to do more with it. There was a recent thread that discussed this.
STRQMQRY can be a pretty-good solution if you are staying on 
green-screen. You might need to play with things like OVRPRTF to get 
report widths right, that kind of thing.
Other graphical tools are there - Paul and Carl mentione SEQUEL, and we 
are using that more and more for new stuff. IBM's Web Query is another, 
heavily promoted by IBM - pricy and complex, IMO. NGS-IQ is another, we 
went with SEQUEL instead.
Web Query can convert and/or consume *QRYDFNs. SEQUEL can convert - 
might be able to consume, haven't checked that. I assume NGS-IQ can do 
similar things. BCD has something called Clover, I think.
If you go the QM route and later decide to go with one of the graphical 
solutions, know that Web Query does not know how to convert or use QM 
stuff. SEQUEL does, maybe the others do - haven't asked.
Rob asks a good question - why the change? Before 7.2, Query for i 
queries had to use the old query engine - as of 7.2, they can run in the 
new query engine.
QM is basically a no-cost solution, except for your time. And it IS 
"green" only without something like SEQUEL. You DO get variable 
substitution with it, if you decide to add markers - Query for i queries 
with mail-merge variables can be run with substitute values, as I recall.
The interface in STRQM can be used in a way that looks like that of 
WRKQRY. Then you can flip over to SQL presentation and get more flexibility.
If you need more information on QM, start with the "Query Manager Use" 
manual - should be under the database manuals on Knowledge Center.
HTH
Vern

On 5/8/2015 10:03 AM, Mark S Waterbury wrote:
Dan:

You probably already have IBM's Query Manager/400 installed on your system ... try typing in the command STRQM and see what happens.
The RTVQMQRY and RTVQMFORM commands can retrieve information from the 
older *QRYDFN objects to assist with converting to *QMQRY and 
*QMFORM.  See also the ANZQRY command for advice or warnings about 
things that require "manual intervention" when converting.
HTH,

Mark S. Waterbury

> On 5/8/2015 10:55 AM, Dan wrote:
Was asked just this morning for suggestions on SQL-based report writers,
such as Sequel. I haven't used any such product in ages, so I'm really not sure what's out there. Note that I am not the decision maker on this, so
all I will do is pass along information.

Any such product should be able to convert (preferred) or use existing
*QRYDFN objects.

Suggestions on what to look for as well as what to avoid are welcomed.

- Dan





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 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 copyright@midrange.com.

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