• Subject: RE: OPNQRYF questions...
  • From: "Shaw, David" <dshaw@xxxxxxxxxxx>
  • Date: Wed, 26 Jan 2000 16:43:26 -0500

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

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