Need only Top 3 occurance of a field

Dingu · Posted: Tue Sep 25, 2007 10:43 pm

Hi,

I have two fields in the File. CustomerID and Value. Both are numeric field. File can contain upto 16 "Value" field for a "CustomerID". My need is to sort descending by the field "Value" and pickup 3 Records for a CustomerID. So the output file will contain,

Frank Yaeger · Posted: Tue Sep 25, 2007 11:06 pm

Here's a DFSORT job that will do what you asked for. I assumed your input file has RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes.

Dingu · Posted: Fri Sep 28, 2007 9:49 am

Thank You Frank, It's Working....

Frank Yaeger · Posted: Sat Aug 09, 2008 3:15 am

If you have z/OS DFSORT V1R5 PTF UK90013 (July, 2008) you can now use the new SELECT FIRST(n) function to do this more easily like this.