Field rearrange, sum and exclude



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

Field rearrange, sum and exclude

Postby Shambu » Fri Jun 05, 2020 12:39 pm

Hi All,

There are six Comp-3 fields in my input file. All the six fields are having the same length. I am trying to perform the below set of operations using syncsort.
1. Move first 3 comp-3 fields to 4th, 5th and 6th comp3 fields respectively.
2. Then set the first three fields values as zero.
3. Then take the sum of all six fields. If sum value is zero, then I have to exclude the records from the sort-out file.

Is it possible to perform all the above processes using a sort card? Could someone please give me some directions ?
Shambu
 
Posts: 5
Joined: Tue May 12, 2020 11:56 am
Has thanked: 0 time
Been thanked: 0 time

Re: Field rearrange, sum and exclude

Postby NicC » Fri Jun 05, 2020 2:34 pm

what have you tried so far?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Field rearrange, sum and exclude

Postby Shambu » Fri Jun 05, 2020 11:05 pm

Hi Nic,

I am not getting how to start this using syncsort. We can handle this using a Cobol program. But i am looking for a sort card to achieve this. So if you can give me some directions, then it will be really helpful
Shambu
 
Posts: 5
Joined: Tue May 12, 2020 11:56 am
Has thanked: 0 time
Been thanked: 0 time

Re: Field rearrange, sum and exclude

Postby sergeyken » Sat Jun 06, 2020 2:05 am

Shambu wrote:Is it possible to perform all the above processes using a sort card? Could someone please give me some directions ?

1) What is “sort card”?? Yon cannot do with any card something except playing a game.

2) direction: RTFM
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 408
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times

Re: Field rearrange, sum and exclude

Postby NicC » Sat Jun 06, 2020 2:27 am

BUILD, SUM, EXCLUDE
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post