FORMAT THE FILE SO ALL CHILD UNDER SAME PARENT IN ONE LINE

JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...
azhar
Posts: 2
Joined: Wed May 31, 2023 4:20 pm
Skillset: COBOL, JCL, DB2
Referer: Google

FORMAT THE FILE SO ALL CHILD UNDER SAME PARENT IN ONE LINE

Postby azhar » Wed May 31, 2023 4:27 pm

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

User avatar
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

Postby sergeyken » Thu Jun 01, 2023 3:06 am

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.
Javas and Pythons come and go, but JCL and SORT stay forever.


  • Similar Topics
    Replies
    Views
    Last post