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

Lines merge


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

New User


Joined: 16 Aug 2005
Posts: 54

PostPosted: Thu Mar 01, 2012 8:21 am
Reply with quote

good evening everyone.

does anyone knows how to do this with dfsort (FB, LRECL 200) ?
each 3 lines should be merged into 1 line

Input
Code:
kakfjk ajaijdi aisjdi dsijisjdisjia  iajsidj iajs
AAAA asjdijsidji sa iasjidjas i aisjidjasd
BBBB asjdijsidji sa iasjidjas i aisjidjasd
asdjjd ajsijdiasjid aijs idjasidjiasjdijsaij iajsi
AAAA aoskdksaod oaksod koa oakosdk oka
BBBB oasdoka ais09idaksa oaksokdo93 ok


Output

Code:
kakfjk ajaijdi aisjdi dsijisjdisjia  iajsidj iajs AAAA asjdijsidji sa iasjidjas i aisjidjasd BBBB asjdijsidji sa iasjidjas i aisjidjasd
asdjjd ajsijdiasjid aijs idjasidjiasjdijsaij iajsi  AAAA aoskdksaod oaksod koa oakosdk oka  BBBB oasdoka ais09idaksa oaksokdo93 ok


Note: first line should be succeeded of AAAA and then BBBB
Note: first word of each first line may vary
Note: AAAA and BBBB never changes
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Thu Mar 01, 2012 10:15 am
Reply with quote

Hi,

search for RESIZE (a DFSORT/ICETOOL operator)


Gerry
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: Thu Mar 01, 2012 2:54 pm
Reply with quote

Do you need the records to be "concatenated" in the sense that trailing blanks on the records are to be ingored for putting them together?

If so, can you have multiple blanks embedded in the data, and if so, can we assume you'd like them retained?
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 577
Location: USA

PostPosted: Thu Mar 01, 2012 9:02 pm
Reply with quote

knobi,
See if below helps...

Code:
//STEP0001 EXEC PGM=ICETOOL                 
//TOOLMSG  DD  SYSOUT=*                     
//DFSMSG   DD  SYSOUT=*                     
//IN       DD  INPUT FB/200                 
//OUT      DD  OUTPUT FB/600               
//TOOLIN   DD  *                           
RESIZE FROM(IN) TO(OUT) TOLEN(600)         
/*                                         


Thanks,
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 Merge two VSAM KSDS files into third ... JCL & VSAM 6
This topic is locked: you cannot edit posts or make replies. Merge 2 input files based on the reco... JCL & VSAM 2
No new posts Merge 2 input files after sort SYNCSORT 14
No new posts I need a 4 lines block where substrin... DFSORT/ICETOOL 12
No new posts Copy few lines from SYSOUT of 10 mill... All Other Mainframe Topics 5
Search our Forums:

Back to Top