IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Syncsort- Merging two records into one line


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kvgreddy1

New User


Joined: 30 Mar 2021
Posts: 7
Location: India

PostPosted: Tue Mar 30, 2021 11:47 pm
Reply with quote

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
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1590
Location: Andromeda Galaxy

PostPosted: Tue Mar 30, 2021 11:50 pm
Reply with quote

You need to use


INREC IFTHEN + WHEN=GROUP + RECORDS=2 + PUSH

Plenty of examples available



Moving to SYNCSORT
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2723
Location: NYC,USA

PostPosted: Wed Mar 31, 2021 12:10 am
Reply with quote

It looks like you are ignoring earlier provided solutions.
ibmmainframes.com/viewtopic.php?p=351696#351696
ibmmainframes.com/about53716.html
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 563
Location: Bamberg, Germany

PostPosted: Wed Mar 31, 2021 1:34 am
Reply with quote

Better start with https://www.ibmmainframeforum.com
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Merging 2 files but ignore duplicate... DFSORT/ICETOOL 1
This topic is locked: you cannot edit posts or make replies. copy file 2 data into file1 for match... DFSORT/ICETOOL 4
No new posts Write records with 3 or less rows in ... DFSORT/ICETOOL 3
No new posts retrieve volume records from decollec... DFSORT/ICETOOL 4
No new posts SYNCSORT/ICETOOL JOINKEYS SORT Statem... DFSORT/ICETOOL 13
Search our Forums:

Back to Top