Re: KLIST question

Don't forget option five, good old FMTDTA.

Regards,
Rich

At 11:30 PM 4/10/01 -0500, you wrote:


>On Wed, 11 Apr 2001 Gary.Brown@appliedchemicals.com 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
> >
>
>Basically, you have 4 options:
>
>1) The the WHOLE file in RPG, and ignore anything that doesn't match
>      the date you specified.   (Not a method I would recommend)
>
>2) Run an OPNQRYF on the file, and read that.   Note that this doesn't
>      actually require a CL program, you could run the OPNQRYF directly
>      from your RPG program.
>
>3) Use SQL.  This would basically yield the same result as the OPNQRYF,
>      but SQL is a much more standard method of accessing databases than
>      OPNQRYF.
>
>4) Use a logical file.
>
>
>Each method has its pros and cons.  Unless the file is tiny, I wouldn't
>give much thought to option #1.   If saving the space, etc of a logical
>file is more important than instant response time, I'd use option #2.
>If speed is more important I'd use option #4.
>
>Option #3 may be a better choice, but I wouldn't use it because I don't
>own the SQL licensed program. :)  So I use OPNQRYF instead.
>
>
>
>+---
>| 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
>+---

Regards,
Rich

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