Re: Suggestions for replacing WRKQRY -- MIDRANGE-L

To add to this - you CAN use STRQMQRY and specify the *QRYDFN as boththe query and the form.

Now this will use default handling of things and may not give you whatyou want - summary-only, for example, is just not done this way - you'dhave to do more with it. There was a recent thread that discussed this.

STRQMQRY can be a pretty-good solution if you are staying ongreen-screen. You might need to play with things like OVRPRTF to getreport widths right, that kind of thing.

Other graphical tools are there - Paul and Carl mentione SEQUEL, and weare 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, wewent 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 dosimilar things. BCD has something called Clover, I think.

If you go the QM route and later decide to go with one of the graphicalsolutions, know that Web Query does not know how to convert or use QMstuff. SEQUEL does, maybe the others do - haven't asked.

Rob asks a good question - why the change? Before 7.2, Query for iqueries had to use the old query engine - as of 7.2, they can run in thenew 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 variablesubstitution with it, if you decide to add markers - Query for i querieswith 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 ofWRKQRY. 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 yoursystem ... try typing in the command STRQM and see what happens.
The RTVQMQRY and RTVQMFORM commands can retrieve information from theolder *QRYDFN objects to assist with converting to *QMQRY and*QMFORM. See also the ANZQRY command for advice or warnings aboutthings 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'mreally notsure what's out there. Note that I am not the decision maker onthis, 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