At 08:42 AM 12/3/1997 -0500, you wrote:
>Midrange Group MGSL wrote:
>> Hi All !
>> I would like to know how to handle OPNQRYF if same file with two different
>> members are used in the one OPNQRYF statement i.e how to specify fields in
>> Mapfield or Keyfield or Qryslt.
>> Thanks in advance,
>Try this, I think it will work, but I don't have time to test.
>ovrdbf file1 tombr(member1)
>ovrdbf file2 tofile(file1) tombr(member2)    
>(file2 does not exist)
>do the opnqry just as if you had two separate files (same format)

That'd probably work, but, as I say in another reply here, OPNQRYF's syntax
can handle this situation, since you can name members in the list of files
(FILE parameter) and you can use what amount to aliases (numbers) in the
other parameters.

I mean, the oft-maligned OPNQRYF (by me and others) is a very powerful
tool. It's just SOOOOO blame hard to learn at first—extremely
non-intuitive, IMHO. I like SQL a lot beter—nice plain English syntax.


Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480

| 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 MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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].