× 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.



Comments inserted below - I've given presentations on QM for several years, I don't know everything, but a fair amount. Used to use them in early days for form letters and OfficeVision - that's where the replacement variable technique comes from that Simon Hutchinson presents.

All speak of RTVQMQRY - Darryl wasn't asking for what that does, but the information is good to look at, once you bite the bullet and go with QMQRY and QMFORM.

Cheers
Vern

On 1/30/2023 4:46 PM, Troy Foster via MIDRANGE-L wrote:
https://www.mcpressonline.com/programming-other/general/techtip-retrieve-query-management-query-rtvqmqry
    A RTVQMQRY article - it doesn't exactly match Darryl's requirements, it also has an error in that the record length of the source file for QMQRY is supposed to be 91 - article says 150.
https://www.ibm.com/support/pages/node/643471
    This is interesting - it gives the basic use of STRQMQRY ALWQRYDFN(*YES) or RTVQMQRY to get source. It also makes note that things do not always convert as expected or at all. It has a link to passing parameters to a Query/400 Query that doesn't work.
https://www.nicklitten.com/modernize-as400-iseries-query-convert-to-ibm-i-sql/
    Another RTVQMQRY article - good example, as far as it goes - nothing is quite so simple as the author claims, right?
https://www.itjungle.com/2004/05/26/fhg052604-story01/
    Yet another (albeit good, too) RTVQMQRY article. Bruce does mention the 91 length for the source file. He shows how to add substitution variables in the resulting source, not in Query for i, again, helpful but not what Darryl asked for.

Hope these help.

On 1/30/2023 3:48 PM, a4g atl wrote:
Caution: This is an external email. Please take care when clicking links or opening attachments. When in doubt, contact your IT Department

I've read a few places that this can be done, saving one having to convert
a QRYDFN to a QMQRY.
I have tried to find examples on how to do this, but have not had success.
The examples I find show the QRYDFN being run but there are steps missing,
it appears. I need to keep the QRYDFN's as the users create the reports. I
am trying to schedule the queries in the scheduler passing from and to
dates.

Does anyone know how to do this?

TIA, Darryl Freinkel


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-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.