Sort to get Max value from file on one column

shivani_jha · New User Joined: 12 Feb 2007 Posts: 11 Location: mumbai

I have a sequential file LREC=80.

abc 2007-02-21-00.00.00.000000 ddd ddd
abc 2007-02-20-00.00.00.000001 ddd ddd
abc 2007-01-21-00.00.00.000010 ddd ddd
abc 2007-02-05-00.00.00.000009 ddd ddd
abc 2007-02-05-00.00.00.000009 ddd ddd
abc 2006-02-21-00.00.00.000000 ddd ddd
abc 2007-01-01-00.00.00.000000 ddd ddd

I have to fetch the Max value of time stamp field from all records using SORT.

How can I find the MAX value of field from postion 4 length 26 bytes and write the max value to a new file using sort.

guptae · Posted: Wed Feb 21, 2007 5:05 pm

Hi There,

You can use following sort card

Frank Yaeger · Posted: Wed Feb 21, 2007 10:14 pm

Shivani,

4,26 doesn't correspond to the input records you show. Either you meant 5,26 or the timestamp starts in position 4, not 5. At any rate, here's a more efficient way to do what you want with DFSORT then Ekta showed, since it uses a copy rather than a sort.

guptae · Posted: Thu Feb 22, 2007 10:08 am

HI Frank,

Thanks for optimizing it.

Does my method give a solution correctly?

Frank Yaeger · Posted: Thu Feb 22, 2007 9:19 pm