Joined: 09 Apr 2014 Posts: 2 Location: United States
Thanks Dick & Jerryte!
Jerryte, I like your idea. I will use it in future. Alhough yesterday I resorted to using 3 steps to do this.
1) Sort the base using ICETOOL datasort ignoring header and trailer.
2) Sort and inrec build the lookup to keep keys and what I needed to pull.
3) Joinkeys the two above, using SORTED and NOSEQCK options.
Jerryte, I think I could have done it in one step using your trick. I am already in UAT so lazy to go back for this one
I hope you don't run into any performance issues in case of millions of records.. So you may wants to check the CPU and elasped time by having actual volume of production. If it is going to be less records then that should be fine.