RE: Passing parameters to a query

[Joe Giusto <JGiusto@xxxxxxxxxxxx>]

Did I miss something here?  Why would you have to copy the data into a
Physical before using it.  How about OVRDBF file SHARE(*YES), the OPNQRYF
and run program or QRY?

Joe Giusto II
Patuxent Publishing Company
 <mailto:jgiusto@patuxent.com> mailto:JGiusto@patuxent.com
http://www.lifegoeson.com <http://lifegoeson.com> 


-----Original Message-----
From:   Dan Bale [SMTP:dbale@genfast.com]
Sent:   Tuesday, June 22, 1999 4:04 PM
To:     RPG400-L@midrange.com
Subject:        RE: Passing parameters to a query
<snip>

Christopher's suggestion of using OPNQRYF is good as long as you realize
that
you have to use CPYFRMQRYF after the OPNQRYF to get the data into a physical
data file; big files could eat up a lot of resources.  If this is the case,
I'd
just as soon scrap the query and write an RPG program to process the
OPNQRYF'd
data.

- Dan Bale


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *