View previous topic :: View next topic
|
Author |
Message |
kvgreddy1
New User
Joined: 30 Mar 2021 Posts: 7 Location: India
|
|
|
|
Hi All,
I have a file with records like this
Code: |
00:00:01 AAAAAAAA AAAAAAAA
00:00:01 RECEIVED SENT STATE: INACTIVE
00:00:01 BBBBBBBB BBBBBBBB
00:00:01 RECEIVED SENT STATE: REPLICATE
00:00:01 CCCCCCCC CCCCCCCC
00:00:01 RECEIVED SENT STATE: REPLICATE
00:00:01 DDDDDDDD DDDDDDDD
00:00:01 RECEIVED SENT STATE: REPLICATE
00:00:01 EEEEEEEE EEEEEEEE
00:00:01 RECEIVED SENT STATE: REPLICATE
00:00:01 FFFFFFFF FFFFFFFF
00:00:01 RECEIVED SENT STATE: REPLICATE |
this file was generated from SAR. i need rows lines in single line. Is there any simple jcl to extract above file as in below format.
AAAAAAAA, BBBBBBBB, CC.... are the job names and it's status was added in next line. I just need job name and it's status in single row as below.
is file join keys will work here ?
Output File:
Code: |
AAAAAAAA AAAAAAAA STATE: INACTIVE
BBBBBBBB BBBBBBBB STATE: REPLICATE
CCCCCCCC CCCCCCCC STATE: REPLICATE
DDDDDDDD DDDDDDDD STATE: REPLICATE
EEEEEEEE EEEEEEEE STATE: REPLICATE
FFFFFFFF FFFFFFFF STATE: REPLICATE |
|
|
Back to top |
|
 |
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006 Posts: 1586 Location: Andromeda Galaxy
|
|
|
|
You need to use
INREC IFTHEN + WHEN=GROUP + RECORDS=2 + PUSH
Plenty of examples available
Moving to SYNCSORT |
|
Back to top |
|
 |
Rohit Umarjikar
Global Moderator

Joined: 21 Sep 2010 Posts: 2632 Location: NYC,USA
|
|
Back to top |
|
 |
Joerg.Findeisen
Active User

Joined: 15 Aug 2015 Posts: 452 Location: Bamberg, Germany
|
|
Back to top |
|
 |
|