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

Finding total sum of fields using SYNCSORT


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
PadmaPriya
Warnings : 2

New User


Joined: 19 Jan 2007
Posts: 3
Location: Bangalore

PostPosted: Mon Jan 22, 2007 2:19 pm
Reply with quote

Hi

My report has 3 fields and I want the output to be sorted based on the first field and find the total sum of the next field for all the records.

I want them to be done using any SORT or SYNCSORT.


In SYNCSORT, I want to know abt the SUM FIELDS= in detail.


Can anyone help in this regard?
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Mon Jan 22, 2007 2:51 pm
Reply with quote

Have you looked at a manual?
Back to top
View user's profile Send private message
manihcl85
Warnings : 1

New User


Joined: 11 Jan 2007
Posts: 52
Location: chennai

PostPosted: Mon Jan 22, 2007 4:32 pm
Reply with quote

USE THE STAEMENT FOR THE FIELDS U WANT TO FIND THE SUM

SUM FIELDS=(START POSITION,LENGTH,TYPE)
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 Finding and researching jobs All Other Mainframe Topics 0
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts VB to FB - Finding LRECL SYNCSORT 4
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Finding Assembler programs PL/I & Assembler 5
Search our Forums:

Back to Top