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
 

 

SPLICE and WITH options

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

New User


Joined: 09 Jun 2007
Posts: 1
Location: Pune

PostPosted: Fri Sep 12, 2008 4:08 pm    Post subject: SPLICE and WITH options
Reply with quote

Can anybody tell the purpose of WITH option which is used along with SPLICE while using the ICETOOL utility? I have two files, FileA and FileB. There are some records which are common two both the files. I want to have third file which has the common records from both the files. I've only one column in both the files at location 41 and length is 10. I've used the following control card.
Code:

//TOOLIN   DD  *                                         
  COPY FROM(DD1) TO(T1)                                   
  COPY FROM(DD2) TO(T2)                                   
  SPLICE FROM(CONCAT) TO(MATCH) ON(41,10,CH) WITH(41,10) 
/*

But when this job is submitted it is giving ABEND=S000 U0016. What may be the issue ?
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Fri Sep 12, 2008 4:12 pm    Post subject: Reply to: SPLICE and WITH options
Reply with quote

post the sysout,
with all the messages,

if the messages start with wer You are using syncsort and You posted to the wrong forum

if the messages start with ice You are using dfsort/icetool
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Fri Sep 12, 2008 4:23 pm    Post subject: Reply to: SPLICE and WITH options
Reply with quote

Avn,

Welcome to the forums.

Quote:
Can anybody tell the purpose of WITH option which is used along with SPLICE while using the ICETOOL utility?


Refer to the forum manuals.

Quote:
I have two files ,FileA and FileB.There are some records which are common two both the files?I want to have third file which has the common records from both the files


You can use SPLICE/SELECT operators of ICETOOL.

Quote:
//TOOLIN DD *
COPY FROM(DD1) TO(T1)
COPY FROM(DD2) TO(T2)
SPLICE FROM(CONCAT) TO(MATCH) ON(41,10,CH) WITH(41,10)
/*


Do you have a DD named CONCAT in your JCL?? Post the JCL adn the entire SYSOUT messages.
Back to top
View user's profile Send private message
Skolusu

Senior Member


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

PostPosted: Fri Sep 12, 2008 9:03 pm    Post subject:
Reply with quote

avn808,

Check this link which explains in detail about splice and it operand description in detail

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.13

Hope this helps...

Cheers
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 DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm
No new posts Endevor - Compiler Options. Chetan Kumar Mainframe Interview Questions 4 Tue Oct 20, 2015 6:32 pm
No new posts Matching records using splice for COM... hiravibk DFSORT/ICETOOL 4 Sun Sep 27, 2015 12:05 pm
No new posts DFSORT with Reformat Options jegan_selvan DFSORT/ICETOOL 4 Tue Oct 14, 2014 4:52 pm
No new posts JOINKEYS or SPLICE? while retaining h... hsinaz50 DFSORT/ICETOOL 4 Thu Apr 17, 2014 12:13 am


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