|
Gary - within RPG , i would use RPGSQL. only used it once, but it looked fairly easy to implement... though, i believe it was ILE maybe someone else can provide you with the info. Else, create a logical that is only maintained when used. good luck kmh At 11:05 PM 4/10/2001, you wrote: >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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.