Re: Send a parm to a query?

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

STRQMQRY can be used in place of RUNQRY, if this parm is in the record
selection area.

STRQMQRY QMQRY(LIBRARY/QRYDFN) QMFORM(*QMQRY) ALWQRYDFN(*ONLY) SETVAR((PARM
10))

Thw statement will even use column layout information from the QRYDFN.

You would put this in record selection:

FIELD   EQ      :PARM

The colon (:) makes PARM a replacement variable. It behaves like &VAR in a
query management query..You'll be prompted in Query/400 for  some
additional information. Just use 1 for query, then put in the name of any
query. This info is not used by STRQMQRY.

The Query Management Programming manual, chapter 12, has more information.

There are restrictions - look in the Query Management Programming book
mentioned.

Regards

Vern

At 04:33 PM 8/2/02 -0500, you wrote:
>I have a query that I run for a user. It was created in WRKQRY. I have one
>parm that I change then I run the query for them. How can I pass a parm into
>this (or similar) query. I would like to avoid a RPG program if possible
>because what I have works great. We do have query manager (if that matters),
>but I am not very familiar with that program.
>
>Thanks for any help,
>
>Mike