Re: Running a QRYDFN using STRQMQRY to pass the parameters

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