Page 1 of 1

Field rearrange, sum and exclude

PostPosted: Fri Jun 05, 2020 12:39 pm
by Shambu
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 ?

Re: Field rearrange, sum and exclude

PostPosted: Fri Jun 05, 2020 2:34 pm
by NicC
what have you tried so far?

Re: Field rearrange, sum and exclude

PostPosted: Fri Jun 05, 2020 11:05 pm
by Shambu
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

Re: Field rearrange, sum and exclude

PostPosted: Sat Jun 06, 2020 2:05 am
by sergeyken
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

Re: Field rearrange, sum and exclude

PostPosted: Sat Jun 06, 2020 2:27 am
by NicC
BUILD, SUM, EXCLUDE