[How to ] Find Max of the given records through Sort
Posted: Fri Jun 01, 2012 2:22 pm
Hi ,
I have a flat file which contains policyno(8) and due date(8) . It should return policy no with its max duedate .
Input :
00112345 20051201
00112345 20101205
00112345 20110120
00112345 20120112
00125692 20040801
00125692 20090912
00136759 20100509
00136759 20110406
00136759 20120101
O/p:
00112345 20120112
00125692 20090912
00136759 20120101
I know its possible through cobol .but is it possible through dfsort or icetool .Thanks in advance .
I have a flat file which contains policyno(8) and due date(8) . It should return policy no with its max duedate .
Input :
00112345 20051201
00112345 20101205
00112345 20110120
00112345 20120112
00125692 20040801
00125692 20090912
00136759 20100509
00136759 20110406
00136759 20120101
O/p:
00112345 20120112
00125692 20090912
00136759 20120101
I know its possible through cobol .but is it possible through dfsort or icetool .Thanks in advance .