Field rearrange, sum and exclude

Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL
Shambu
Posts: 5
Joined: Tue May 12, 2020 11:56 am
Skillset: Cobol jcl db2
Referer: Google

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 ?

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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

Shambu
Posts: 5
Joined: Tue May 12, 2020 11:56 am
Skillset: Cobol jcl db2
Referer: Google

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

User avatar
sergeyken
Posts: 458
Joined: Wed Jul 24, 2019 10:12 pm
Skillset: Assembler, JCL, Utilities, PL/I, C/C++, DB2, SQL, REXX, COBOL, etc. etc. etc.
Referer: Internet search

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.

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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


  • Similar Topics
    Replies
    Views
    Last post