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
range lookup on hashed file
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 252
- Joined: Mon Sep 19, 2005 10:28 pm
- Location: Melbourne, Australia
- Contact:
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.
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.
Ross Leishman
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 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.
viewtopic.php?t=84998
We found it to be an effective solution.