hey folks, have no idea to this problem:
input like
a1234 10 22,34
a1234 10 7,34
a1234 10 22,34
a1234 100 -22,34
wished output
a1234 10 22,34
a1234 10 7,34
the task is: if i found a positive amount to the key 10 and the same amount negative to key 100 both records should be eliminted. if there is any other record with the key 10 with the same amount it should be also in the output record. the task is finding siblings wiht key 10 and 100 which results by arithmetic add function to null. in my example 22,34 + (-22,34) results in 0 and the first record 22,34 and the second record 7,34 should be in the output file. so any icetool or dfsort command isn't the resolution. I think it must be a combination of more steps but i have no idea.
complicated deleting duplicates in dataset
- 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: complicated deleting duplicates in dataset
1. This is not JCL. Use SORT instead.
2. Learn how to use the Code button when posting your code/data samples.
2. Learn how to use the Code button when posting your code/data samples.
Javas and Pythons come and go, but JCL and SORT stay forever.
-
- Similar Topics
- Replies
- Views
- Last post
-
-
eliminate duplicates with different data
by cobol_dev » Fri Jun 03, 2022 3:47 am » in DFSORT/ICETOOL/ICEGENER - 7
- 1858
-
by cobol_dev
View the latest post
Wed Jun 15, 2022 10:44 pm
-
-
- 2
- 2711
-
by willy jensen
View the latest post
Sat Mar 04, 2023 12:41 pm
-
- 12
- 3776
-
by RalphEagle
View the latest post
Fri Jul 30, 2021 1:00 pm
-
- 3
- 2606
-
by sergeyken
View the latest post
Sat Nov 16, 2024 11:05 pm
-
- 1
- 1242
-
by sergeyken
View the latest post
Wed Feb 07, 2024 11:48 pm