DSXchange

I am using one hash file in 2 -3 server jobs . Column required in all the jobs are different ,so i have selected only required columns in respective jobs.
the above three job are running on daily basis . At the time of inserting the hash file ,some how one of the record is getting rejected .
To solve this problem , I had to clear the hash file completely and load it again and It worked fine .

Now my question is " What could be the possible cause of above issue ?"
Is it because of selecting differnet number of columns in the jobs ?

moulipx wrote:some how one of the record is getting rejected

You need to understand that hashed file columns are positional and you are asking for nothing but trouble if you leave out columns or specify them in different orders unless you really know what you are doing. And it's hard to help with an insert issue if you don't tell us what the actual error message was.

Also clarify for us - do these three jobs run simultaneously? Do all three write to the hashed file?

And what the heck about this makes it any kind of "urgent!!" ?

What Craig said.