Re: OPNQRYF QRYSLT Question...

Hi Eric !
While reading the Online Book examples I saw the %RANGE and remember THINKING I
should check that out but got sidetracked with what I was already doing (tunnel
vision) <G>...
OK, so here is what I have:
OPNQRYF FILE((WFBLBLSP)) QRYSLT('BLDN07=%RANGE("' *TCAT &START *TCAT'" "' *TCAT
&END *TCAT '")')
and I get:
Character ''' not valid following string '*TCAT '.
Hate to be a pest but what am I missing ?
Thanks !
Chuck
eric.delong@pmsi-services.com wrote:
> I think you might want to try:
> ('BLDN07=%RANGE("' *tcat &START *tcat'" "' *tcat &END *tcat '")')
>
> eric.delong@pmsi-services.com
>
> ______________________________ Reply Separator
>_________________________________
> Subject: OPNQRYF QRYSLT Question...
> Author: <MIDRANGE-L@midrange.com > at INET_WACO
> Date: 7/12/99 2:29 PM
>
> Hi Folks,
>
> Been a LONG time since I've used OPNQRY. Used to do all sorts of tricky
> things with it including KILLER searches. Only problem is, all examples
> are gone (old job) and I'm in DUH mode. Tried online books (IBM) and
> can't seem to find exactly what I need.
>
> Here goes...
>
> Need to be able to pass 2 parameters to a CL which will do OPNQRY on a
> file.
> The parameters are both 3 characters. The field I'm checking is a Bin
> Label location field and is BLDN07 (not that this matters to you) and
> the fields I'm passing are a starting Bin Location (&START) and an
> Ending Bin Location (&END).
>
> For example, I am wanting to run Bin Labels for locations E02 - E10.
>
> If I have the QRYSLT defined as:
>
> QRYSLT('BLDN07 *GE *BCAT &START)
>
> It takes that fine. When I go to add a *AND BLDN07 *LE &END) it goes
> nuts...
>
> What am I missing ? I seem to remember using the " in these strings...
>
> TIA !!
>
> Chuck
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].