IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Syncsort to SUM records
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
krsenthil85

New User


Joined: 31 Aug 2007
Posts: 55
Location: bangalore
PostPosted: Fri Feb 26, 2010 5:52 pm
 Reply with quote
I have to sumup for the following data

My input is

Code:
 024   CBS   000 000 005 
 024   CBS   001 000 000 
 024   CBS   000 000 001 
 024   WEB   000 000 004 
 024   WEB   000 000 002 
 024   WEB   003 000 000 



My output should be like below

Code:
 024   CBS   001 000 006
 024   WEB   003 000 006 


Last 3X3 bytes are used in summing the records.
Some one please help me to achieve this.
Back to top
View user's profile Send private message
GMBUKU

New User


Joined: 24 Feb 2010
Posts: 1
Location: Germany
PostPosted: Fri Feb 26, 2010 6:03 pm
 Reply with quote
Code:

  SORT FIELDS=(7,3,CH,A)                     
  SUM FIELDS=(13,3,21,3),FORMAT=ZD     
  OPTION ZDPRINT                             


best regards icon_razz.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 

Similar Topics
Topic Forum Replies
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us