View previous topic :: View next topic
|
Author |
Message |
siva102
New User
Joined: 28 Nov 2007 Posts: 63 Location: Chennai
|
|
|
|
Hi Gerry,
I m still not getting the required output.
The output that i got right now is same as the previous one only. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Siva,
Can you post the contents of input data you used at positions- (1,99,CH) and (122,278,CH)
Thanks,
Arun |
|
Back to top |
|
|
siva102
New User
Joined: 28 Nov 2007 Posts: 63 Location: Chennai
|
|
|
|
Hi all,
At last the work got completed.
Thanks to everyone. I really learned a lot of things here.
The SORT CARD that i used was,
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(1,99,CH) ON(122,278,CH) -
ALLDUPS DISCARD(SORTXSUM)
Thank u all..... With out u guys help i cannot even move a little more step.
Once again thaks for u guys concerns abt the task. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Siva,
Thanks for letting know that you reached your solution . Still I m not clear on the below part.
Quote: |
If my file is having 3 duplicate records then one record is going to OUT1 and the other two to OUT2.
But i need aal the 3 records need to goto OUT2. |
Using ALLDUPS will route all the unique-keyed records to your DISCARDdd which is nothing but your "OUT2". Is n't it contradicting your above statement.
Please let me know if I m missing something here.
Thanks,
Arun |
|
Back to top |
|
|
siva102
New User
Joined: 28 Nov 2007 Posts: 63 Location: Chennai
|
|
|
|
Hi arun,
What you pointed is correct only but the ultimate result i want is to remove the duplicates from the input file.
So here by using ALLDUPS i got all the duplicates to OUT1.
Where ever it goes may be but i was able to separate the duplicates, right ???
Thank you very much for your concern. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for the follow-up
d |
|
Back to top |
|
|
|