Re: FMTDTA to OPNQRYF

[Vernon Hamberg <hambergv@xxxxxxxxxxxxxx>]

Rick

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.

Cheers

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
+---