Re: Passing parameter to a query

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Pedro, I believe that is the only way to do this. (You COULD use OPNQRYF by 
building the command string every time, but nobody wants to work that hard 
anymore.)

Merge fields in Query/400 come from database files and cannot be used for 
this. But you can RTVQMQRY from a QRYDFN with merge fields and get the 
substitution variables automatically.

I recommend using uppercase for the variable name, otherwise you need to 
quote the variable name in the SETVAR parameter.

Look at the Query Management Programming manual (under Database in 
InfoCenter) for help on substitution variables, esp. about quoted strings, 
converting QRYDFNs, lots of tips that are not found in the Query Manager 
manual, etc.

HTH

Vern

At 10:01 AM 3/24/2003 +0000, you wrote:
> Hi midrangers,
>
> I want to pass to a query (In a CL pgm) a variable containing the member of
> the file. I think its possible to pass variables to query by strqmqry, in
> that case, is it the best way to do it ?
>
> Thanks !
>
>
>
> Cordialement,
> Best regards,
> -------------------------------------------------------------------
> Pedro Reis