Re: PROBLEM WITH OPNQRYF

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.