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