to get last Rec

prabhu2006 · New User Joined: 09 Jan 2006 Posts: 5

Hi,
How do you get the last record in a file by using Sort/Icetool whose total count of recs is unknown?

Thanks & Regards
Prabhu

rajesh_1183 · Posted: Mon Jan 09, 2006 6:05 pm

Hi prabhu,

Try this ....

assuming the key is like a number
1
8
3
6
5
4
2
10
9....

if u sort in descending order...........the records will be in this order
1
2
3
4
5
6
7
8
9
10

if u sort in descending order...........the records will be in this order
10
9
8
7
6
5
4
3
2
1

where the last record is at top...so to retrive that record use "STOPAFT=1"

which will retrieve the record with key 10 which is a last record after sorting..........

corrections welcomed........

Thanks,
Rajesh

rajesh_1183 · Posted: Mon Jan 09, 2006 6:07 pm

sorry the first sort is as per in ascending order

rajesh_1183 · Posted: Mon Jan 09, 2006 6:27 pm

or simply sort using descending order and fetch the first record by "STOPAFT=1" which will be the last record(when sorted in ascending order)

Thanks,
Rajesh

Frank Yaeger · Posted: Mon Jan 09, 2006 9:19 pm

See the "Keep the last n records" Smart DFSORT Trick at:

Use [URL] BBCode for External Links

prabhu2006 · New User Joined: 09 Jan 2006 Posts: 5

Thaz cool...got it friends

Frank Yaeger · Posted: Thu Sep 25, 2008 2:08 am

You can now do this kind of thing quite easily using the new SUBSET operator of DFSORT's ICETOOL available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008) like this: