RE: OPNQRYF questions...

1.  The only way I know to feed a second OPNQRYF from an earlier one is to
output the first one to a temporary file, using CPYFRMQRYF or the HLL of your
choice.  If you find another way, I'd certainly like to know.

2.  The file opened is the one specified on OPNQRYF's OPNID parameter.  This
defaults to *FILE, which is the first file in the join.  My preference in a join
is normally to use the name of the record format file as the OPNID, so that I
can compile my HLL programs using that name.  To make that work, I have to code
an override before the OPNQRYF like this:

OVRDBF FILE(record format file) TOFILE(first file in join) SHARE(*YES)

Note: I always include the SHARE(*YES) even if that's already the file's
attribute, since the file could be changed tomorrow and my OPNQRYF would stop
working.

Dave Shaw


-----Original Message-----
From: Mary Koetting [mailto:Mary_Koetting@mail.mchcp.org]
Sent: Wednesday, January 26, 2000 1:51 PM
To: 'midrange'
Subject: OPNQRYF questions...


1.  I want to use a series of OPNQRYFs where the results of the first is
used in the second and those results used in a third, is this even possible?

2.  If the OPNQRYF is joined with the record format specified, what file is
the opened one?  Is it the first one specified in the join, or the one
specified as the record format?

Examples would be helpful as the books aren't...  Thanks!
+---
| 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
+---