https://www.mcpressonline.com/programming-other/general/techtip-retrieve-query-management-query-rtvqmqryA 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/643471This 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
Does anyone know how to do this?
TIA, Darryl Freinkel
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.