Sum an alphanumeric fields



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: Sum an alphanumeric fields

Postby BillyBoyo » Tue Jul 08, 2014 8:08 pm

Well, apart from the ".X." left over from the earlier thing you showed, and some subtraction from 10,000 to get the xxxx value, you should be about there.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Re: Sum an alphanumeric fields

 

Re: Sum an alphanumeric fields

Postby danylele74 » Wed Jul 09, 2014 1:10 am

Sorry, but i don't understand you answer.
danylele74
 
Posts: 11
Joined: Thu Jul 03, 2014 2:00 am
Has thanked: 0 time
Been thanked: 0 time

Re: Sum an alphanumeric fields

Postby BillyBoyo » Wed Jul 09, 2014 5:23 am

Delete the ",X". Subtract that final value from 10,000, which will give you the remaining length of the record after the field whose sum you want. Replace the xxxx with the result of your calculation. Try it out.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Sum an alphanumeric fields

Postby danylele74 » Wed Jul 09, 2014 3:54 pm

It works !!! Thank you very much.

Here the solution:

SORT FIELDS=(13,9,CH,A),FORMAT=BI                             
OUTFIL REMOVECC,NODETAIL,                                     
SECTIONS=(13,9,                                               
TRAILER3=(1:1,3673,                                           
     TOT=(3674,19,SFF,EDIT=(STTTTTTTTTTTTTTT.TT),SIGNS=(+,-)),
          3693,6307))                                         
danylele74
 
Posts: 11
Joined: Thu Jul 03, 2014 2:00 am
Has thanked: 0 time
Been thanked: 0 time

Re: Sum an alphanumeric fields

Postby Magesh23586 » Wed Jul 16, 2014 9:15 pm

Why are you sorting with character as well as Binary ?

SORT FIELDS=(13,9,CH,A),FORMAT=BI


Regards
Magesh
Magesh23586
 
Posts: 35
Joined: Sat Jul 05, 2014 5:36 pm
Has thanked: 1 time
Been thanked: 3 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post