Re: OPNQRYF Question

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.