|
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: 1592
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: 3051
Location: NYC,USA
|
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1246
Location: Bamberg, Germany
|
|
| Back to top |
|
|
CarolynP
New User
Joined: 29 Dec 2021
Posts: 6
Location: United States
|
|
|
|
| I'm trying to use Syncsort and need to insert a date from a control card file into the beginning of records in a second file. Not sure how to get this completed. I've created files for both so that the lrecl is the same. |
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1246
Location: Bamberg, Germany
|
|
|
|
| CarolynP wrote: |
| I'm trying to use Syncsort and need to insert a date from a control card file into the beginning of records in a second file. Not sure how to get this completed. I've created files for both so that the lrecl is the same. |
Please start a new topic for your request. Provide samples of input and desired output. |
|
| Back to top |
|
|
|
|
