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

How to get a 20digit sum in syncsort??


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

New User


Joined: 15 Mar 2006
Posts: 14

PostPosted: Tue Apr 04, 2006 3:06 am
Reply with quote

How to get the sum if the sum is a 20 digit no??
I am using in my jcl
TRAILER1=(1:TOT=(19,6,PD,EDIT=(SIIIIIIIIIIIII.II),SIGNS=(,-)))
I have to get the sum of the field from 19 to 24.

But this will only gives the resultant sum less than or equal to 15digit length.

I know this can be done with dfsort but how to achieve the same in syncsort.
My company use syncsort.

Please help.
Back to top
View user's profile Send private message
jasorn
Warnings : 1

Active User


Joined: 12 Jul 2006
Posts: 191
Location: USA

PostPosted: Wed Jul 12, 2006 5:31 pm
Reply with quote

JAYANT KUMAR SAHOO wrote:
How to get the sum if the sum is a 20 digit no??
I am using in my jcl
TRAILER1=(1:TOT=(19,6,PD,EDIT=(SIIIIIIIIIIIII.II),SIGNS=(,-)))
I have to get the sum of the field from 19 to 24.

But this will only gives the resultant sum less than or equal to 15digit length.

I know this can be done with dfsort but how to achieve the same in syncsort.
My company use syncsort.

Please help.


AFAIK you can't do this in syncsort. PD is limited to 15 digits. So you have to use workarounds to handle this. Let me know if you find out there is a way to get syncsort to handle PD with more than 15 digits.
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 only first records of the fil... SYNCSORT 7
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts DFSORT/SYNCSORT/ICETOOL JCL & VSAM 8
No new posts Syncsort "Y2C" Function SYNCSORT 1
No new posts Arithmetic division using Syncsort SYNCSORT 6
Search our Forums:

Back to Top