View previous topic :: View next topic
|
Author |
Message |
avn808
New User
Joined: 09 Jun 2007 Posts: 1 Location: Pune
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007 Posts: 1287 Location: Chennai, India
|
|
|
|
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 |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
Back to top |
|
|
|