Re: FMTDTA to OPNQRYF

[Richard Baird <rbbaird@xxxxxxxxxxx>]

Vernon Hamberg wrote:

>>ovrdbf file1 tombr(member1)
>>
>>ovrdbf file2 tofile(file1) tombr(member2)    
>>
>>(file2 does not exist)

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

Once the overrides are in place, don't specify the member names in the
opnqryf statement.  Treat it as if 2 different files completely. 

On second thought, maybe that won't work - It would try to treat it as a
"Join" rather than a "merge", wouldn't it.  Oh well, nice try anyway.

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

I've used a lot of opnqryf in the past, but sql is so much more "hip". 

sorry I couldn't help,

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