range lookup on hashed file

kkreddy · Post by **kkreddy** » Sun Jan 15, 2006 11:21 pm

Dear DsGurus,
Is There anyway to perform Range look up on a Hashed File .if there is any how it is?

Thanks in advance
Kiran Kumar

Sreenivasulu · Post by **Sreenivasulu** » Sun Jan 15, 2006 11:54 pm

HI,

As far as i know range lookup is not possible in hashed file as of now. We
have to go through the database query way as of now

This is one the likely features being implemented in the HAWK release.

Regards
Sreenivasulu

rleishman · Post by **rleishman** » Mon Jan 16, 2006 12:02 am

I have seen several posts in this forum advising that you can use the UV stage rather than the Hashed File Stage.

Since a Hashed File is really just a UniVerse table in disguise, you can use the UV stage to lookup the file using SQL.

Note that you may need to index the table/file in order to get accepable performance.

chulett · Post by **chulett** » Mon Jan 16, 2006 12:10 am

In other words, searching the forum for the words range lookup will provide quite a number of interesting conversations on the topic.

Sreenivasulu · Post by **Sreenivasulu** » Mon Jan 16, 2006 3:19 am

HI,

I think UV stage is also used to store all the matching records for a key .
Eg: 1 key having mulitple values

Regards
Sreenivasulu

dls · Post by **dls** » Mon Jan 16, 2006 9:13 am

In case it's not included in the results of your search, you might want to consider this post from Ken Bland.

viewtopic.php?t=84998

We found it to be an effective solution.