DSXchange

Thanks Craig, for your quick reply hope that will work but the one you are missing in my previous post is The hash file what I am creating doesn't have any date restrictions that mean it goes after all the data in the database with IntialEntry 0. But the database where I do a lookup on should take D...

Thanks Craig. Please can you be more specific. I understand the stage variables but how do I keep using it until I find another 0. What could be my logic on the stage variable and I guess I have to sort the data before I use any stage variables. Hope you will help in completing. (SV1 and SV2) are tw...

Yes, I am using those three fileds as the key columns. If it doesn't work in that way with the hash files then I guess there should be some other way to solve this kind of problem.

Hope I will get helped with the sulution.

thanks,
rcil