sort add with in same record fields

kalyan.v · New User Joined: 04 Feb 2008 Posts: 65 Location: Hyd

Hi,

My requirement is that i need to add the fields in the same record as below using DFSORT :-

Pay-amt Bill-amt
100 200
300 500

For every record i need to add Pay-amt and Bill-amt and generate a new column Tot-amt :- Pay-amt + Bill-amt.

Kindly let me know on how to do this using DFSORT.

Thx,
Kalyan

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

Kalyan,
please provide us LRECL , record format for the input file,field position along with their datatypes

thanks,

CICS Guy · Posted: Thu Jun 24, 2010 7:17 pm

Take a look at How to sum two columns in a file....