Hi All,
This is my requirement , let me know if anyone has a solution for this.
I have 2 input files and I need to compare the total credit amount row in both the input files and if the amounts are matching then I should write the record into the output file as a single row.
INPUT FILE 1
005 CREDIT
010 CREDIT
015 CREDIT
TOTAL CREDIT AMOUNT1 : 123456.78
INPUT FILE 2
001 CREDITS
004 CREDITS
008 CREDITS
010 CREDITS
TOTAL CREDIT AMOUNT2 : 123456.78
OUTPUT FILE EXPECTED
TOTAL CREDIT AMOUNT1 : 123456.78,TOTAL CREDIT AMOUNT2 : 123456.78
Is this possible?
TIA
Regards,
Tesa
Compare selected rows of 2 different file
- prino
- Posts: 641
- Joined: Wed Mar 11, 2009 12:22 am
- Skillset: PL/I - CICS - DB2 - IDMS - REXX - JCL, most in excess of three decades
- Referer: Google
- Location: Vilnius, Lithuania
- Contact:
Re: Compare selected rows of 2 different file
And which idiot PHB has come up with this requirement? What's the flipping use of writing out totals when they're the same?????
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
robert.ah.prins @ the.17+Gb.Google thingy
Re: Compare selected rows of 2 different file
Hi Prino,
It's a typo , its actually not* matching.
I need to compare the total credit amount row in both the input files and if the amounts are not matching then I should write the record into the output file as a single row.
It's a typo , its actually not* matching.
I need to compare the total credit amount row in both the input files and if the amounts are not matching then I should write the record into the output file as a single row.
- 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: Compare selected rows of 2 different file
The question is not related to JCL, not even a bit.
Hint: read about SORT utilities, DFSORT, and/or SYNCSORT
Neither of them is JCL!!!
Hint: read about SORT utilities, DFSORT, and/or SYNCSORT
Neither of them is JCL!!!
Javas and Pythons come and go, but JCL and SORT stay forever.
-
- Similar Topics
- Replies
- Views
- Last post
-
- 6
- 4451
-
by MemoPerez
View the latest post
Tue Oct 24, 2023 10:07 pm
-
- 1
- 2487
-
by enrico-sorichetti
View the latest post
Fri Apr 02, 2021 6:56 pm
-
- 5
- 1760
-
by willy jensen
View the latest post
Fri Dec 03, 2021 8:16 pm
-
- 3
- 3802
-
by sergeyken
View the latest post
Thu Mar 25, 2021 7:12 pm
-
-
strategy: partitioned table, delete millions of rows
by BobHarris » Wed Aug 17, 2022 2:47 pm » in DB2 - 1
- 1930
-
by engh
View the latest post
Tue Sep 20, 2022 1:56 pm
-