Hello Frank, and Fran. PIPE run well.
"pipe < cpux9 batchw a | sort 1-8 descending 63-65 | > cpux9 batd a" Thanks very much for your help. Regards, Sergio > Date: Tue, 4 Jan 2011 09:37:44 -0500 > From: f...@zvm.sru.edu > Subject: Re: Sort Fields Question > To: IBMVM@LISTSERV.UARK.EDU > > Sergio - > > Take a look at HELP PIPE SORT. > > 'PIPE < cpux9 batchw a | sort 1-8 descending 63-65 | > cpux9 batd a' > > /Fran Hensler at Slippery Rock University of Pennsylvania USA for 47 years > mailto:f...@zvm.sru.edu http://zvm.sru.edu/~fjh +1.724.738.2153 > "Yes, Virginia, there is a Slippery Rock" > -------------------------------------------------------------------------- > On Tue, 4 Jan 2011 17:10:16 +0300 Sergio Lima said: > > > >Hello List, > > > >We have a CMS file, with some fields. > >One of this field is a date, in the DD/MM/YY format. > >We also have 200 records medium by day. > >Another field, is a numeric percentage that I need get the top 50 for each > >day. > >So, We think execute a sort under a REXX EXEC , like this : > > > >trace r > >queue "1 8 63 65" > >"sort cpux9 batchw a cpux9 batd a " > >exit > > > >But, looking on HELP of sort command can't see the descending option. > > > >We think this, because after the sort, will write another REXX that read only > >the first 50 records , and write another output file. > > > >Someone already have used the sort with descending order, or know if have > >another way to do this? > > > >Thanks very much, > > > >Sergio Lima Costa > >Sao Paulo - Brazil