Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
JAYANT KUMAR SAHOO

New User

Joined: 15 Mar 2006
Posts: 14

 Posted: Tue Apr 04, 2006 3:06 am    Post subject: How to get a 20digit sum in syncsort?? 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.

jasorn

Active User

Joined: 12 Jul 2006
Posts: 154
Location: USA

Posted: Wed Jul 12, 2006 5:31 pm    Post subject: Re: How to get a 20digit sum in syncsort??

 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.
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us