Re: How to split a file into two file and remove dups?
Posted: Thu Oct 18, 2012 9:32 pm
I didn't get you.If possible, can u explain it.
There is no need of splitting. I split the records because at a time i can arrange either MAX-NMBR in descending order or MIN-NMBR in ascending order. Thats why i used two steps of sort.
I tried using OUTFIL option so that single step will achieve two things, but OUTFIL does not support DUPKEYS keyword.
In that old post, 3nadh suggested the merge solution, but with that at time only one field will be arranged in either max or min order.
Exactly its not a client requirement, I am doing this to reduce the CPU time used by a JOB.
There is no need of splitting. I split the records because at a time i can arrange either MAX-NMBR in descending order or MIN-NMBR in ascending order. Thats why i used two steps of sort.
I tried using OUTFIL option so that single step will achieve two things, but OUTFIL does not support DUPKEYS keyword.
In that old post, 3nadh suggested the merge solution, but with that at time only one field will be arranged in either max or min order.
Exactly its not a client requirement, I am doing this to reduce the CPU time used by a JOB.