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

How to use splice


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

New User


Joined: 02 Jun 2006
Posts: 3

PostPosted: Mon Apr 05, 2010 6:42 pm
Reply with quote

Hi,I have input like below

Code:
1111| F| 2222|F|0   |
1111|  | 2222| |3333|F
1111|  | 2222| |4444|F


I would like to get the output as below

Code:
1111| F| 2222|F|3333|F
1111| F| 2222|F|4444|F


can this be performed using SPLICE?
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Mon Apr 05, 2010 8:39 pm
Reply with quote

shantid,

You have provided very little information. Assuming that the first 4 bytes is the key , the following DFSORT/ICETOOL JCL will give you the desired results

Code:

//STEP0100 EXEC PGM=ICETOOL                                       
//TOOLMSG  DD SYSOUT=*                                           
//DFSMSG   DD SYSOUT=*                                           
//IN       DD *                                                   
----+----1----+----2----+----3----+----4----+----5----+----6----+-
1111| F| 2222|F|0   |                                             
1111|  | 2222| |3333|F                                           
1111|  | 2222| |4444|F                                           
//OUT      DD SYSOUT=*                                           
//TOOLIN   DD *                                                   
  SPLICE FROM(IN) TO(OUT) ON(1,4,CH) WITH(9,6) WITH(16,8) WITHALL
//*
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 Join multiple records using splice DFSORT/ICETOOL 5
This topic is locked: you cannot edit posts or make replies. Splice JCL into one record for DD sta... SYNCSORT 2
This topic is locked: you cannot edit posts or make replies. Splice multiple records into single r... DFSORT/ICETOOL 9
No new posts Splice more than 50 occurances DFSORT/ICETOOL 1
No new posts Matching records using splice for COM... DFSORT/ICETOOL 4
Search our Forums:

Back to Top