Re: OPNQRYF Question

Hi Gary,

Without having the actual files to try it out, I'm not sure, but how about
something like:

OPNQRYF    FILE((COURSES) (TBLLOOKUP)) FORMAT(COURSES) +
             QRYSLT('SOMECODE = "" *AND LEVEL = "02" +
             AND (TABLEID =' *BCAT &TNAME1 *BCAT '*OR +
             TABLEID =' *BCAT &TNAME2 *TCAT ')') +
             JFLD((COURSES/LOCATION TBLLOOKUP/ID *EQ)) +
             ALWCPYDTA(*OPTIMIZE)

HTH

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----
From: Gary Munroe <GMUNROE@flemingc.on.ca>
To: <MIDRANGE-L@midrange.com>
Sent: Wednesday, July 05, 2000 11:35 AM
Subject: OPNQRYF Question


> I've got a little logic problem when working with OPNQRYF that I
> know I can do in straight SQL (which is not available for my
> process).  I'm thinking OPNQRYF might not be able to handle it.
> Essentially I want to do the following via the OPNQRYF command:
>
> SELECT * FROM COURSES
>   WHERE SOMECODE = "" AND
>   LOCATION IN
>     (SELECT ID FROM TABLELOOKUP
>      WHERE LEVEL = "02" AND (TABLEID = &TNAME1
>            OR TABLEID = &TNAME2)
>     )
>
> Basically the user could enter up to two region names (&TNAME1
> and &TNAME2) which use a lookup table containing the real location
> codes that have to be compared with the codes on file.
>
> Can someone tell me whether this is possible or not?
>
> Thanks.
>
>
>  ___________________________________________________________________
> | Gary Munroe                                                      |
> |------------------------------------------------------------------|
> | I.T.S., Information Services Group  Work: gmunroe@flemingc.on.ca |
> | Sir Sandford Fleming College        Home: izzi@calweb.com        |
> | (705) 749-5523 x1409                                             |
> |__________________________________________________________________|
> +---
> | 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
> +---


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.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
+---