Re: OPNQRYF versus LF

["alan shore" <SHOREA@xxxxxxxx>]

You can use incorporate the command CPYFRMQRYF with the OPNQRYF so that a file 
can be created within whichever library you wish.

>>> "Osvaldo Rodrigues" <Osvaldo.Rodrigues@brainag.com> 03/23 1:04 PM >>>



Hello!
I have a PGM that does a selection on a LF file by one or more fields. In that
selection we have a field that you can
select more than one value (allows a maximum of 5) for that field. Lets suppose
that it is 2Alfa and you had entered values '50','60' and '70' for a given
selection.

At this moment I am reading each record of the query file and comparing the
refered field to each of those values (I
inserted them in an array). I think this is a litle bit hassle, running all the
file and for each record seeking the array.

I know that if I use the OPNQRYF  it would help restricting the number of
records. But since it creates the query file as a temporary file and I also need
to do some updates to the file I dont know how to do this.

One last question how can I measure in therms of perfomance and processing time
the 2 ways ?

I must confesse that I never used the OPNQRYF only read some stuff about it.

Any help would be great!

Thanks a lot.

Osvaldo Rodrigues
AS400 Programmer

BRAIN Portugal
A BRAIN International Company

BIW Iberia- Informatica Lda
Av. Joao Canavarro, 305   Phone:   +351 252 248-120
Edificio Alameda   Fax:   +351 252 248-111
4480-668 Vila do Conde
Portugal
e-mail:            Osvaldo.Rodrigues@brainag.com 
Internet:          http://www.brainag.com 

NOTICE    This message contains privileged and confidential information intended
only for the use of the address see named above. If you have received this
message in error please notify BRAIN Portugal immediately.


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com 
+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---