Re: Opnqryf

Not sure why they don't want more LF.

I tried OPNQRYF:

OPNQRYF    FILE((PDFILE)) KEYFLD((PDDATE))

Oops, maybe it did sort by date. The date format is

mmddyy.



    > 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"
> --
> 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.
>
>