Greetings!
I have 2 files customer and transaction of record lengths 80 and 45, both has a header date in the first record
Customer file
CFHDR08/22/2014 <other header details>>
D1111111111 150.00
D2222222222 350.00
D3333333333. 500.00
Transactions file
TFheader20140822<other header details>>
D11111111111 075.00
D11111111111 075.00
D22222222222 315.00
D55555555555 654.00
My output file must have only detail records, matched by the key like 11111111, the decimal is an amount
Output
D11111111111 075.00
D11111111111 075.00
D22222222222 315.00 -- amount from transaction file
D3333333333. 500.00 - also unmatched acct that is not in transaction file
Also, I need to check the header date before I process. Wondering if Sort can handle it.any suggestion is highly appreciated.
Thanks - sreeni1808
Requesting help with sort join
-
- Similar Topics
- Replies
- Views
- Last post
-
-
COBOL SORT - How to sort entire file first & sort by Key
by k_ekam » Thu Dec 01, 2022 12:58 pm » in IBM Cobol - 3
- 1537
-
by Robert Sample
View the latest post
Wed Dec 07, 2022 7:32 am
-
-
- 6
- 2310
-
by engh
View the latest post
Wed Sep 04, 2024 7:41 pm
-
- 5
- 4604
-
by arya_starc
View the latest post
Thu Sep 23, 2021 4:37 pm
-
-
Join parts of two records from same file
by Mickes » Thu Apr 27, 2023 3:47 am » in DFSORT/ICETOOL/ICEGENER - 3
- 1206
-
by sergeyken
View the latest post
Sat Apr 29, 2023 1:32 pm
-
-
- 1
- 1761
-
by prino
View the latest post
Tue Jul 02, 2024 2:23 pm