Re: Passing parameter to a query

["Steve Landess" <steve_landess@xxxxxxxxxxx>]

Query Management queries, like SQL, cannot handle members.  IIRC, unless
specified by an override _before_ running the query, it will alway use the
first member of the file.

You will need to perform a file override in the CL program, before running
the QM query, to override the file to the appropriate member.

Steve Landess
Austin, Texas
(512) 423-0935

----- Original Message -----
From: <pedro.reis@xxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Monday, March 24, 2003 4:01 AM
Subject: Passing parameter to a query


> 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
> Information Systems
> e-mail: pedro.reis@xxxxxxxxx
> Phone: 351-258 350 725
> Fax: 351-258 350060
> --------------------------------------------------------------------
> VALEO - Electronics & Connective Systems
> Viana do Castelo - Portugal
> --------------------------------------------------------------------
>
> "This e-mail message is intended only for the use of the named
> recipient(s).
> The information contained therein may be confidential or privileged, and
> its
> disclosure or reproduction is strictly prohibited. If you are not the
named
> recipient, please return it immediately to its sender at the above address
> and destroy it."
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>