How to sum up the values of columns and put it in a new col

VinayCM · New User Joined: 06 Nov 2007 Posts: 36 Location: Bengaluru

Input file structure
FLD1 FLD2 FLD3 AMT1 AMT2 AMT3

Required output file
FLD1 FLD2 FLD3 AMT1 AMT2 AMT3 SUM

Where SUM = AMT1+AMT2+AMT3

Is this possible in SYNCSORT?

I cannot use DFSORT or ICETOOL as of now.

Let me know if there is any option.

Thanks in advance.

Bhargav_1058 · New User Joined: 13 Dec 2008 Posts: 53 Location: New York

Hi,

The below sort will gives you the desired output.

Input:

VinayCM · New User Joined: 06 Nov 2007 Posts: 36 Location: Bengaluru

Thanks a bunch Bhargav. It worked, otherwise i was planning to use EZTRIEVE for doing this process. Thanks again.