Re: [External] Running a QRYDFN using STRQMQRY to pass the parameters

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

RTVQMQRY only retrieves the SELECT statement that is equivalent to what 
is specified in the QRYDFN - then you have to CRTQMQRY. You can't run 
the source so retrieved.

RUNSQLSTM can't do it, either, because that command will not run bare 
SELECT statements.

Regards
Vern

On 1/30/2023 3:59 PM, webster@xxxxxxxxxxxxxx wrote:
> Retrieve Query Mgmt Query (RTVQMQRY)
>
> Blessings,
> Davey Webster
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Michael Mayer
> Sent: Monday, January 30, 2023 3:47 PM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: RE: [External] Running a QRYDFN using STRQMQRY to pass the
> parameters
>
> Somewhere I have a link to this from IBM ..... give me a few minutes and
> I'll find it and post it.
> MM
>
> Respectfully,
> Michael Mayer
> IBM i on Power System Admin
> Cell: 518.641.8906
> Office and On Call: 731-676-4318
> https://www.ermco-eci.com<https://www.ermco-eci.com/>
> IBM i Blog:
> https://ibmireference.blogspot.com<https://ibmireference.blogspot.com/>
>
>
> [cid:image001.gif@01D934C2.164DAF70]
>
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g
> atl
> Sent: Monday, January 30, 2023 3:48 PM
> To: midrange-l@xxxxxxxxxxxxxxxxxx
> Subject: [External] Running a QRYDFN using STRQMQRY to pass the parameters
>
> Caution: This message originated outside your organization from email
> address
> midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@lists.midran
> ge.com>. Ensure you were expecting this email before opening links or
> attachments.
>
> 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
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email:
> MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
> To subscribe, unsubscribe, or change list options,
> visit:
> https://lists.midrange.com/mailman/listinfo/midrange-l<https://lists.midrang
> e.com/mailman/listinfo/midrange-l>
> or email:
> MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@lists.midran
> ge.com>
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l<https://archive.midrange.com/midrang
> e-l>.
>
> Please contact
> support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any
> subscription related questions.
>
>
> The information in this email may be confidential. It is intended only for
> the person(s) named above. If you are not the intended recipient, please
> notify the sender and do not review, distribute, or duplicate this email.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.