|
This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] First, If you are just starting to use OPNQRYF, then may I suggest that you look at imbedded SQL instead? See if you have the STRSQL command on your system. If so, I would lean towards that route. Database programmers guide http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/dbp/rbafomst02.htm http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/dbp/rbafomst199.htm#HDROPNQF For alternative sources: http://www.greymatter.com/products/00032362.htm http://mc-store.com/mc-store/opquerfilmag2.html I've not read either. But I think you'll run into problems. Using a join logical, an OPNQRYF join, or even a SQL join, and being able to update the view is pretty tough - if not impossible. Perhaps an application for control break headers, or even matching records? Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin "Janell Haskins" <jhaskins@knitrite.com> Sent by: rpg400-l-admin@midrange.com 10/31/2002 09:35 AM Please respond to rpg400-l To: <rpg400-l@midrange.com> cc: Fax to: Subject: OPNQRYF Question I recently "discovered" OPNQRYF and I'm trying to figure out how (or if) it I can use it in my current programming project. Most of the information I need is in a detail file, however, two very important pieces of information (the transaction date and the transaction type) are only in a header file. I was going to create a logical file that joined the two physical files and then let the RPG program determine which records to include in the report, based on parameters entered by the user. I know that I can use OPNQRYF to select the desired records before the RPG program starts. The problem I have is that OPNQRYF will only open a join file in input mode (*INP) and what I need is output mode (*OUT). At least that's how I read the IBM manual. So here's my question, can I use OPNQRYF to select the desired records from the physical files and still use the logical join file to access them from my RPG program? If not, do you have any other suggestions of what I could try? (I'm sure that this could be done with SQL, but I know even less about how to do that than I do about OPNQRYF.) Finally, could you suggest a good resource(s) for learning more about OPNQRYF? Thanks! Janell Haskins Programmer/Analyst Knit-Rite, Inc. (913) 281-4600, ext. 113 _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
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.
midrange.com
