|
|
| Author |
Message |
jsnair
New User
Joined: 26 Sep 2006
Posts: 24
Location: India
|
|
|
|
Hi Skolusu,
This is same JCL as you have posted earlier. I my case there may have Duplicate keys so we need to consider that also. As I had explaied earlier. From my above explanation we van see this here FILE1 contain record with key AL100722922. The same we can see in FILE2. So we need to take this record from FILE1 not from FILE2. In FILE1 there are 5 records and in FILE2 also 5 records. Because there is one duplicate record (AL100722922) we are taking it only from the FILE1. So in output file we should get 9 records. Hope now it is clear. |
|
| Back to top |
|
 |
References
|
 Posted: Mon May 26, 2008 10:58 am Post subject: Re: |
|
|
|
|
Skolusu
DFSORT Developer
Joined: 07 Dec 2007
Posts: 304
Location: San Jose
|
|
|
|
jsnair,
oops I guess I pasted the wrong control cards. Change your toolin statement to the following and re-run your job
| Quote: |
//TOOLIN DD *
SELECT FROM(IN) ON(1,6,CH) TO(OUT) FIRST USING(CTL1)
|
|
|
| Back to top |
|
|
jsnair
New User
Joined: 26 Sep 2006
Posts: 24
Location: India
|
|
|
|
Hi Skolusu,
Thanks very much..It is working fine. |
|
| Back to top |
|
|
|
|
