Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to use splice

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: How to use splice
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    Post subject:
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    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 Matching records using splice for COM... hiravibk DFSORT/ICETOOL 4 Sun Sep 27, 2015 12:05 pm
No new posts JOINKEYS or SPLICE? while retaining h... hsinaz50 DFSORT/ICETOOL 4 Thu Apr 17, 2014 12:13 am
No new posts Match 2 files using SPLICE sudib19 DFSORT/ICETOOL 6 Wed Dec 04, 2013 3:06 am
No new posts Syncsort - SPLICE only certain info. ramsri SYNCSORT 11 Wed Jul 24, 2013 4:48 pm
No new posts compare 2 file based on key+retain du... Hariharan BK DFSORT/ICETOOL 6 Thu May 02, 2013 12:04 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us