|
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: 1590
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: 2790
Location: NYC,USA
|
|
| Back to top |
|
|
Joerg.Findeisen
Active Member
Joined: 15 Aug 2015
Posts: 619
Location: Bamberg, Germany
|
|
| Back to top |
|
|
|
|
