WRITE A JCL TO FORMAT THE FILE SO THAN ALL THE CHILD UNDER ONE PARENT IS IN ONE RECORD
input
PARENT | CHILD
A123456789|B123456789
C123456789|D123456789
A123456789|E123456789
F123456789|G123456789
G123456789|H123456789
I123456789|J123456789
F123456789|H123456789
output
A123456789|B123456789,E123456789
C123456789|D123456789
F123456789|G123456789,H123456789
G123456789|H123456789
I123456789|J123456789
FORMAT THE FILE SO ALL CHILD UNDER SAME PARENT IN ONE LINE
- 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: FORMAT THE FILE SO ALL CHILD UNDER SAME PARENT IN ONE LI
JCL is not able to do this.
Please, choose another tool which is available and/or preferable, and you are familiar with:
- SORT
- FileAid
- COBOL
- PL/I
- Assembler
- 100 other tools.
JCL is THE ONLY ONE not suitable for this task.
Please, choose another tool which is available and/or preferable, and you are familiar with:
- SORT
- FileAid
- COBOL
- PL/I
- Assembler
- 100 other tools.
JCL is THE ONLY ONE not suitable for this task.
Javas and Pythons come and go, but JCL and SORT stay forever.
-
- Similar Topics
- Replies
- Views
- Last post
-
- 12
- 4045
-
by sergeyken
View the latest post
Wed Jan 29, 2025 8:49 pm
-
- 3
- 1199
-
by sergeyken
View the latest post
Wed May 18, 2022 4:40 pm
-
- 11
- 3680
-
by willy jensen
View the latest post
Thu Oct 15, 2020 1:25 am
-
-
How to overlay a constant value in PD format
by Shambu » Mon Jun 28, 2021 11:56 pm » in Syncsort/Synctool - 1
- 3499
-
by sergeyken
View the latest post
Tue Jun 29, 2021 1:18 am
-
-
-
comparte two fileds on the same line
by samb01 » Thu Mar 23, 2023 6:27 pm » in DFSORT/ICETOOL/ICEGENER - 2
- 1095
-
by samb01
View the latest post
Thu Mar 23, 2023 9:30 pm
-