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

Total of the numbers SYNCSORT/TOOL...


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

Active User


Joined: 28 Sep 2005
Posts: 210
Location: St Katherine's Dock London

PostPosted: Tue Apr 14, 2009 9:50 pm
Reply with quote

Hi,

I have some 0.3 million records in a sequential file like below:

Code:

0019.0300
0113.2300
0000.0000
0100.0000
0000.0500
.
.


is it possible to get a total (i.e. sigma) of all these numbers using SYNCSORT/TOOL?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 14, 2009 10:04 pm
Reply with quote

Hello,

Syncsort supports UFF - Unsigned Free Format for data that does not contain a sign.

There is also SFF (Signed Free Format) if the data contains a sign.
Back to top
View user's profile Send private message
genesis786

Active User


Joined: 28 Sep 2005
Posts: 210
Location: St Katherine's Dock London

PostPosted: Tue Apr 14, 2009 10:45 pm
Reply with quote

great thanks dsch.. icon_smile.gif
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 14, 2009 11:35 pm
Reply with quote

You're welcome - good luck icon_smile.gif

d
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 Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Generate random number from range of ... COBOL Programming 3
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Error while running web tool kit REXX... CLIST & REXX 5
Search our Forums:

Back to Top