Strange behaviour of a hash file

gpbarsky · Post by **gpbarsky** » Mon May 09, 2005 3:50 pm

Hi, my friends....

Y have a hash file, and a BASIC routine accessing it. Everything is fine, and suddenly one record is not stored in the hash file.

This hash file is fed from a SAP table.

There were no changes to the SAP table, no changes to the hash file, no changes related to this small environment.

So, the question is: why from one day to another, a record is missing ?

Since several months it was working fine, but now there is one record that is not stored.

Is there any maintenance to do with hash files ? The size of this file is about 100Kb.

Thanks in advance.

clshore · Post by **clshore** » Mon May 09, 2005 5:16 pm

It would help if you posted some more info, like the hash file structure.
How do you know that the record is missing? What are the keys? Is a key-combo that was there before now gone, or are non-key values associated with an existing key-combo now different?

Carter

ray.wurlod · Post by **ray.wurlod** » Mon May 09, 2005 5:44 pm

Records can not "go missing" from hashed files unless a specific DELETE statement (or command) is issued.
It is possible, of course, that the hashed file has become corrupted; you would need to check for this.
And your answer to Carter's question might help us to target an answer a little more accurately.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue May 10, 2005 3:23 am

Try writing the same recs into a seq file for comparison.

gpbarsky · Post by **gpbarsky** » Tue May 10, 2005 9:28 am

Thanks for answering.

It was an application problem, because my development and production environments get mixed. So, I thought that the data I was seeing was from production, but really was from development.

Thanks again.