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

SPLICE and WITH options


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Fri Sep 12, 2008 4:12 pm
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: 1287
Location: Chennai, India

PostPosted: Fri Sep 12, 2008 4:23 pm
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
Reply with quote

avn808,

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

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 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 COBOL MVS options COBOL Programming 8
No new posts Splice more than 50 occurances DFSORT/ICETOOL 1
Search our Forums:

Back to Top