Re: PROBLEM WITH OPNQRYF

["rick baird" <rick.baird@xxxxxxxxx>]

Ken, exactly.

and just to clarify, the CL variable (&DIV) must be an alpha variable
to concatenate, regardless if the file variable is alpha or numeric.

On 8/18/06, Ken Sims <mdrg5003@xxxxxxxxxxx> wrote:
> Hi Bob -
>
> >   First off, I thought *CAT is used only for numeric variable.  &DIV is a
> >    one character field as is the GTDIV field in the file.
> >
> >    Second, If I take out the lines with:
> >
> >    *AND GTDIV *EQ &DIV
>
> You have to use *CAT (or *BCAT or *TCAT) for any kind of variable so that
> the contents of the variable are substituted into the select.
>
> Numeric:
>
> ... *AND FIELD *EQ ' *CAT &NUMBER *CAT ' ...
>
> Character:
>
> ... *AND FIELD *EQ "' *CAT &ALPHA *CAT '" ...
>
> Note the double quotes on either side of the concatenated value for
> character fields.  You could also use a pair of single quotes but the
> double quotes are much nicer to work with.
>
> Ken
> http://www.kensims.net/
> Opinions expressed are my own and do not necessarily represent the views
> of my employer or anyone in their right mind.
>
> --
> 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.