But I can achieve the desired output by
step1: splitting the file into credits and debits based on account no
step2: sorting the credit file in descending order
step3: sorting the debit file in ascending order
step4: merging the credit and debits file based on account no...
Is there any smarter and simpler way of achieving this using DFSORT?
(PS:MERGE PTF for ICETOOL is not installed in our system..Peculiarly the usage of ICETOOL is frowned upon here for unknown reason... )
********************************* TOP OF DATA **********************************
30000201234123,+000000000000005
30000201234123,+000000000000004
30000201234123,+000000000000003
30000201234123,+000000000000002
30000201234123,+000000000000001
30000201234123,-000000000000000
30000201234123,-000000000000001
30000201234123,-000000000000002
30000201234123,-000000000000003
30000201234123,-000000000000004
******************************** BOTTOM OF DATA ********************************