RE: opnqry Vs LF

You should use a logical file compiled with the option MAINT =  *DLY.




                    "Tyler, Matt"
                    <mattt@wincofoods        Para:   "'rpg400-l@midrange.com'"
                    .com>                    <rpg400-l@midrange.com>
                    Enviado por:             cc:
                    rpg400-l-admin@mi        Asunto:      RE: opnqry Vs LF
                    drange.com


                    11/10/2002 15:58
                    Por favor,
                    responda a
                    rpg400-l





Matt,
           The size should not dictate the need for an index (LF) but the
frequency the index will be used should.  If the only place the index is
used is in this program and only when OPNQRYF is used then why waste system
resources maintaining an index that big?  OPNQRYF can be modified to
optimize the building of the temporary index.

Thank you,
Matt Tyler
Mattt@wincofoods.com

-----Original Message-----
From: Haas, Matt [mailto:Matt.Haas@thomsonlearning.com]
Sent: Friday, October 11, 2002 12:52
To: rpg400-l@midrange.com
Subject: RE: opnqry Vs LF

<snip>
Since, the program is only run once a month there is no great need to
create
a logical file.
<snip>

Unless it's a huge file that can take hours to index.

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