Re: KLIST question

[booth@xxxxxxxxxxxx]

I'm thinking that a logical over this file, by date, might get used more 
often in the future.    The cost isn't high for a logical like this and 
might prove helpful with queries too?

Logical files are easily understood, easily planned, and a normal 
extension of the data base.  What reason would you have for not wanting to 
add this one?

_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________




Gary.Brown@appliedchemicals.com
Sent by: owner-rpg400-l@midrange.com
04/10/2001 11:05 PM
Please respond to RPG400-L

 
        To:     RPG400-L@midrange.com
        cc: 
        Subject:        KLIST question


I have a logical over my invoices file, the KLIST for it is

 KEYINV    KLIST
           KFLD           CUSNO
           KFLD           CSITE
           KFLD           INVDT


My question is how can I retrieve all the invoices for a particular date
regardless of customer or site

I know I could simply create another logical, but it seems a little bit 
wasteful
to create a logical for just one report that will be run once a day.

I also know that I could do a OPNQRYF in my CL first and limit the records 
that
way and then read all records in my RPG/400.

Just wondering if there is a way to do it from within RPG/400.

Thanks,
Gary.


+---
| 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
+---