Re: Logical File sort

["Richard ECUYER" <recuyer@xxxxxxx>]

many ways :
1- change the logical (descending order)
2- if you only want YTD > 0 initialize YTD key with one.
3- use embeded sql
4- use opnqryf
5- if it is not a big file, read records into a table, define muti field in
that table, and sort it.
.....
If you have SQL, a very good and flexible apporach is option 3 for me.
hope this help

----- Original Message ----- 
From: "Douglas W. Palme" <dpalme@xxxxxxxxxxxxxxxxxxxxx>
To: "RPG Group" <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, March 23, 2005 5:35 PM
Subject: Logical File sort


> In the previous issue I had with the subfile I'm using a logical file for
> the data, its keyed on the salesman number and also on the YTD sales
amount,
> but I have noticed that the YTD sales amount is starting with all those
> accounts with zero, is there a way to have it sort descending versus
> ascending order?
>
> -- 
> 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.
>
>