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 ?
Field rearrange, sum and exclude
-
- 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
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
Regards
Nic
Re: Field rearrange, sum and exclude
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
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
- 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
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.
-
- 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
BUILD, SUM, EXCLUDE
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
Regards
Nic
-
- Similar Topics
- Replies
- Views
- Last post
-
- 1
- 1753
-
by sergeyken
View the latest post
Fri Mar 26, 2021 11:59 pm
-
- 2
- 1543
-
by sergeyken
View the latest post
Sun Jan 26, 2025 3:07 am
-
-
sort card to add zeros to varying alphanumeric field.
by longfall » Thu Mar 09, 2023 12:03 am » in DFSORT/ICETOOL/ICEGENER - 1
- 1807
-
by sergeyken
View the latest post
Thu Mar 09, 2023 2:04 am
-