RE: OPNQRYF

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

Is C1SCAC a character field?  If so, you need the ' marks around the value
for comparison.  You also might find it easier to use the %range operator
for checking for a numeric field between two values.

Scott Mildenberger

> -----Original Message-----
> From: fkany@averittexpress.com [mailto:fkany@averittexpress.com]
> Sent: Wednesday, December 18, 2002 2:59 PM
> To: midrange-l@midrange.com
> Subject: OPNQRYF
>
>
> Hello,
>
> Can anyone see what I'm doing wrong or missing out of OPNQRYF #2?
>
> ==================
> OPNQRYF #1 works:
> ==================
> OPNQRYF    FILE((CPP001)) QRYSLT('C1ADAT *GE ' *CAT +
>                                  &FRDAT *CAT ' *AND C1ADAT
> *LE ' *CAT +
>                                  &TODAT) KEYFLD((C1CODE) (C1ADAT))
>
> ===========================
> OPNQRYF #2 DOES NOT work:
> ===========================
> OPNQRYF    FILE((CPP001)) QRYSLT('C1ADAT *GE ' *CAT +
>                                  &FRDAT *CAT ' *AND C1ADAT
> *LE ' *CAT +
>                                  &TODAT *CAT ' *AND C1SCAC
> *EQ ' *CAT +
>                                  &SCAC) KEYFLD((C1CODE) (C1ADAT))
>
> Below is the error message from job dump:
>
> "Field TOWE on QRYSLT pa QQQBLQDT
>  parameter not found."
>
> TOWE is the value of &SCAC.  &SCAC is parameter being passed
> into the program.