RE: PROBLEM WITH OPNQRYF

[Ken Sims <mdrg5003@xxxxxxxxxxx>]

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.