mc.satya
New User
Joined: 11 Oct 2009
Posts: 1
Location: Chennai,India
|
|
|
|
I have to sort a particular file and sum certain fields of the same file.
Also I need to manipulate a particular field of the output file based on the summed up values.
Here goes my sort parameters:
| Code: |
SORT FIELDS=(1,3,CH,A,4,10,CH,A,14,4,CH,A,18,1,CH,A,51,1,CH,A,
76,3,CH,A)
SUM FIELDS=(19,8,27,8,35,8,43,8,52,8,60,8),FORMAT=ZD
OUTREC OVERLAY=(19:19,8,ZD,EDIT=(IIIIIIIT),27:27,8,ZD,EDIT=(IIIIIIIT),
35:35,8,ZD,EDIT=(IIIIIIIT),43:43,8,ZD,EDIT=(IIIIIIIT),
52:52,8,ZD,EDIT=(IIIIIIIT),60:60,8,ZD,EDIT=(IIIIIIIT),
68:68,8,(60,8,ZD,DIV,35,8,ZD),MUL,+100,TO=ZD)
|
the 68 th position field has a length of 8 and it should be manipulated from the calc (60 position field / 35 position field) * 100. |
|
