Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Concatenaing multiple rows to single row based on a key

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Vignesh Sid

New User


Joined: 04 Sep 2017
Posts: 33
Location: India

PostPosted: Tue Aug 14, 2018 8:59 am    Post subject: Concatenaing multiple rows to single row based on a key
Reply with quote

Hi all,

I have FB file with record length 3000 with records similar to below code:

Code:

----+----1----+----2----+----3----+----4----+----5----+----6
11111111  111  AAAAAAAAAA               SUBJECT1           
11111111  111  AAAAAAAAAA               SUBJECT2           
11111111  111  AAAAAAAAAA               SUBJECT3           
11111111  111  AAAAAAAAAA               SUBJECT4           
11111111  111  AAAAAAAAAA               SUBJECT5           
11111111  111  AAAAAAAAAA               SUBJECT6           
11111111  111  AAAAAAAAAA               SUBJECT7           
11111111  111  AAAAAAAAAA               SUBJECT8           
11111111  111  AAAAAAAAAA               SUBJECT9           
11111111  111  AAAAAAAAAA               SUBJECT10           
11111111  111  AAAAAAAAAA               SUBJECT11           
11111112  112  AAAAAAAAAB               SUBJECT1
11111112  112  AAAAAAAAAB               SUBJECT2


The output file can be VB and should be like:

Code:

----+----1----+----2----+----3----+----4----+----5----+----6
11111111  111  AAAAAAAAAA               SUBJECT1,SUBJECT2,...,SUBJECT11
11111112  112  AAAAAAAAAB               SUBJECT1,SUBJECT2

Could anyone suggest me a way to achieve this.

Thanks,
Viky.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2031
Location: NY,USA

PostPosted: Tue Aug 14, 2018 10:53 am    Post subject:
Reply with quote

Sure.Search for RESIZE Or SPLICE in DFSORT.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DUMP A Multi volume datasets and rest... lind sh JCL & VSAM 6 Mon Oct 01, 2018 12:02 pm
No new posts Need help on the multiple files refor... wik123 DFSORT/ICETOOL 7 Wed Sep 19, 2018 10:47 am
No new posts Delete Multiple rows in chunks by usi... dharmaraok DB2 5 Tue Sep 11, 2018 8:44 pm
No new posts Merge two files and sum up the count ... preeti6 JCL & VSAM 6 Thu Sep 06, 2018 10:57 am
No new posts Remove selected duplicate rows from t... hnharish DFSORT/ICETOOL 3 Wed Sep 05, 2018 3:11 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us