Re: Repeat IBM's Easy to find info books. Followup

After I experimented further I found that QRYSLT('flda = -1') works.

My real problem was when I tried it as QRYSLT('flda = %range(-5 2)') -- negative
5 to positive 2. It complained about the minus sign. I called support line and
got the WAD (working as designed) answer. The tech reported that the %RANGE was
intended as a *CHAR function and the hard copy manual stated that it would
accepted Quoted Character, Character and digit character operands. Although you
are comparing to a decimal field and it will work for positive operands it isn't
even intended to work with negative numbers. Their "Work Around" :-( is to use
QRYSLT('(flda *ge -5) and (flda *le 2)').

The only thing I could do was let the tech close the call with a dissatisfied
result status.

Roger Vicker, CCP

Rick Baird wrote:

> Roger Vicker, CCP wrote:
>
> > When I try QRYSLT('flda = -9') or even QRYSLT('flda = "-1"') I get an
> > error about an improper operator. Does anyone know where to find it or
> > the proper syntax?
>
> Not sure, but try:
>
>         DCL  &WRK *DEC (4 0)
>         DCL  &QSLT *CHAR (30)
>
>         CHGVAR &WRK VALUE(0 - 9)
>         CHGVAR &QSLT
>
>         OVRDBF FILE SHARE(*YES)
>         OPNQRYF FILE QRYSLT('flda *eq ' *CAT &QSLT)
>
> my motto, let it machine figure out how it want's to look at it.
>
> hth,
>
> rick@work.zzz
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
> | To unsubscribe from this list send email to MAJORDOMO@midrange.com
> |    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
> umidr



--
*** Vicker Programming and Service *** Have bits will byte ***
Fer sail cheep, Windows spel chekker, wurks grate.


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---