Merge two files and sum up the count in a single trailer



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Re: Merge two files and sum up the count in a single trailer

Postby gauravnnl » Wed Jan 14, 2015 10:22 pm

Yes Bill... source of the amount is not known. so I have the only option to use the existIng amount value in both the trailers. However I achieve this with my sort card. See above my input and output trailers.

Now the question is to convert the count and amount value in output trailer in signed byte. In my both input trailers count is 1B and 1E so output trailer count should be 2G.same way amount values in both trailers are 22878Q so output trailer should be 45757O being a -ve value.

I have implemented what u told above and got output but not in signed format..thts the only problem remaining.I got count as 27 and amount as 457576 in place of 2G and 45757O. I hope now I clarified the problem. I apologies if this was not clear in my previous post. If u can look at my above sortcard and suggest smthng to get the exact result pls...thanks.
gauravnnl
 
Posts: 21
Joined: Tue Jul 15, 2014 2:25 pm
Has thanked: 3 times
Been thanked: 0 time

Re: Re: Merge two files and sum up the count in a single trailer

 

Re: Merge two files and sum up the count in a single trailer

Postby BillyBoyo » Wed Jan 14, 2015 10:32 pm

Did you look at the ZDPRINT option? This controls whether a positive value from a SUM appears as an F or a C in the sign, which should get you what you want.
SUM
...
You can use installation option ZDPRINT=YES or run-time option ZDPRINT to
specify that positive zoned decimal fields that result from summing are to be
printable. That is, you can tell DFSORT to change the last digit of the zone from
hex C to hex F.


You are using ZDPRINT you can list the options, if that is not done automatically) and you want to use, for this job, NOZDPRINT.

 OPTION NOZDPRINT
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Merge two files and sum up the count in a single trailer

Postby gauravnnl » Thu Jan 22, 2015 5:39 pm

Sorry for the late reply...Actually it worked with NZDPRINT option . Below is the complete sort card for reference.
   INREC IFTHEN=(WHEN=INIT,                                         
                  OVERLAY=(98:SEQNUM,4,ZD,20C'0')),                 
          IFTHEN=(WHEN=GROUP,BEGIN=(1,1,CH,EQ,C'1'),               
                               END=(1,1,CH,EQ,C'9'),               
                  PUSH=(97:ID=1)),                                 
          IFTHEN=(WHEN=(1,1,CH,EQ,C'9'),                           
                  OVERLAY=(98:4C'9',18,20))                         
    OPTION NZDPRINT                                                 
    SORT FIELDS=(98,4,CH,A)                                         
    SUM FIELDS=(102,7,ZD,109,13,ZD)                                 
                                                                   
   OUTFIL IFOUTLEN=96,                                             
          OMIT=(1,1,CH,EQ,C'1',AND,97,1,ZD,NE,1),                   
          IFTHEN=(WHEN=(1,1,CH,EQ,C'9'),                           
           OVERLAY=(18:102,20))                                     


Thanks For your suggestion and help .. Cheers!!!
gauravnnl
 
Posts: 21
Joined: Tue Jul 15, 2014 2:25 pm
Has thanked: 3 times
Been thanked: 0 time

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post