× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.