View previous topic :: View next topic
|
Author |
Message |
JAYANT KUMAR SAHOO
New User
Joined: 15 Mar 2006 Posts: 14
|
|
|
|
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 |
|
|
jasorn Warnings : 1 Active User
Joined: 12 Jul 2006 Posts: 191 Location: USA
|
|
|
|
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 |
|
|
|