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

Rearrange group of colums to one record.


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pradeean

New User


Joined: 08 Jan 2013
Posts: 6
Location: india

PostPosted: Tue Jan 08, 2013 3:29 pm
Reply with quote

Hi All,

I am new to this forum. I have one requirement which I would like to do using DFSORT instead of COBOL program. I have checked in DFSORT material to get the solution but I can able to see only Transpose related solutions. I have mentioned the requirement below. Please let me know if any solutions. Thanks in advance.

Input file: Rec length -80, Type-Fixed Block

Code:

ABC DEF GHI COMMENT1
ABC DEF GHI COMMENT2
ABC DEF GHI COMMENT3
ABC DEF GHI COMMENT4
JKL MNO PQR COMMENT1
JKL MNO PQR COMMENT2
STU VWX YZA COMMENT3
STU VWX YZA COMMENT2
STU VWX YZA COMMENT3
BCD EFG HIJ COMMENT2
KLM NOP QRS COMMENT2
KLM NOP QRS COMMENT1
KLM NOP QRS COMMENT2
KLM NOP QRS COMMENT3
KLM NOP QRS COMMENT5
TUV WXY ZAB COMMENT1
TUV WXY ZAB COMMENT2
TUV WXY ZAB COMMENT3
TUV WXY ZAB COMMENT4
TUV WXY ZAB COMMENT5
TUV WXY ZAB COMMENT6
TUV WXY ZAB COMMENT7


Expected output: Rec length -500, Type-Fixed Block
(Should be take the maximum COMMENTS from input file is 5)
Code:

ABC DEF GHI COMMENT1 COMMENT2 COMMENT3 COMMENT4
JKL MNO PQR COMMENT1 COMMENT2
STU VWX YZA COMMENT3 COMMENT2 COMMENT3
BCD EFG HIJ COMMENT2
KLM NOP QRS COMMENT2 COMMENT1 COMMENT2 COMMENT3 COMMENT5
TUV WXY ZAB COMMENT1 COMMENT2 COMMENT3 COMMENT4 COMMENT5
Back to top
View user's profile Send private message
pradeean

New User


Joined: 08 Jan 2013
Posts: 6
Location: india

PostPosted: Tue Jan 08, 2013 6:58 pm
Reply with quote

Hi,

I have founded the same post in this forum which is similar to my requirement. it is available in http://ibmmainframes.com/about58061.html. Thanks
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Jan 08, 2013 7:13 pm
Reply with quote

Good searching. I believe there are a couple of more recent examples as well.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Jan 08, 2013 10:02 pm
Reply with quote

Hello and welcome to the forum,

Good job looking for and finding what you needed icon_smile.gif

Enjoy the forum!

d
Back to top
View user's profile Send private message
pradeean

New User


Joined: 08 Jan 2013
Posts: 6
Location: india

PostPosted: Wed Jan 09, 2013 9:05 am
Reply with quote

Thank you 'Bill Woodger' and 'dick scherrer'.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
Search our Forums:

Back to Top