RE: Opnqryf

[steema@xxxxxxxxxxxxx]

I'm new here. They said the work file idea is the way to  go,
Thanks,
Steve
> SQL may be able to change that into a date field that you can sort by
> but I have to wonder why that type of field wasn't caught during Y2K
> remediation? If nothing else, you could always build a work file with
> that field in a true date format and use it to print the report. The
> problem with both of these methods are going to be that they're slow
> since a full table scan is required to do the sort or build the file
> (you may be able to use a trigger to keep the work file up to date after
> the initial build).
>
> IMHO, the best way to handle this is going to be storing the date in a
> real date field or at least something that you can sort on like yyyymmdd
> format. A real date field would have the benefit of not needing a bunch
> of logic in programs to do things like put date separators in it. This
> is, however, a ton of work since I'm sure large portions of your system
> touch the files the invoice data is in.
>
> Matt
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of steema@xxxxxxxxxxxxx
> Sent: Thursday, December 22, 2005 4:24 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Opnqryf
>
> Now the dilema is how to get a mmddyy field to flow by year.
> I will do a logical if need be,
>
>  Strictly speaking, OPNQRYF is not appropriate for RPG400-L ... it would
>> be better in MIDRANGE-L
> (http://lists.midrange.com/listinfo/midrange-l).
>>
>> However, that line can be blurry, so I'm not going to insist.
>>
>> david
>>
>> 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.
>>
>>
>
> --
> 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.
>
>
> --
> 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.
>
>