Re: Opnqryf

There are many ways to do this without creating an LF.  I am curious as to
why you wouldn't want to create an LF, but if that is a requirement, then
you have options

1)  OpnQryf -- You can do this and key by date.  I don't have an example,
because I rarely use OpnQryf
2)  You could create an SQL statement that will present the data to your
program in date order (of course, if you CREATE the view, this will be an
LF)
3)  Inside your program, you could create an LF in QTEMP that is sorted by
date, and read from it
4)  You could get real tricky with a DS array, using QSort and BSearch

All of these items will re-index the data each time you run them

On 12/22/05, steema@xxxxxxxxxxxxx <steema@xxxxxxxxxxxxx> wrote:
>
> HI I Have a file that is sorted by invoice number. The requirements for
> the reprt are to list details by year. Yet the date is not part of the
> key.
> I tried an OPNQRYF using the date as the key, but this was ignored.
>
> Did I do this wrong, or is there no way to do this w/out creating another
> logical?
>
> Thanks,
> Steve
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>


--
"Enter any 11-digit prime number to continue..."
"In Hebrew SQL, how do you use right() and left()?..." - Random Thought
"If all you have is a hammer, all your problems begin to look like nails"