Hi All
Need some urgent help Regarding Range Lookup..
I have in A table 3 column
X,Y,z..
Values of X,Y,Z are like ("1A","0.000150",0.000200"")
Now i want to do lookup with this table...
when my input value is between Y and Z...
it shd return me value of X...
Means my query shd be like
Select X from A where Y <= (input value) and z>=(input value);
i know i cannot achieve this with HASH file...
I am thinking to use MetaSQL but i dont have any idea regarding Syntax..to fire in DB2 stage ,,
Please try to give some idea..
Thanks
Himanshu
Range lookup
Moderators: chulett, rschirm, roy
Hi,
I run a quick search with range lokup as key words and checked the search for all key words.
here are some of the things that turned up:
viewtopic.php?t=92264&highlight=range+lookup
viewtopic.php?t=92924&highlight=range+lookup
viewtopic.php?t=93532&highlight=range+lookup
viewtopic.php?t=92113&highlight=range+lookup
there are more out there you only need to search for them
IHTH,
I run a quick search with range lokup as key words and checked the search for all key words.
here are some of the things that turned up:
viewtopic.php?t=92264&highlight=range+lookup
viewtopic.php?t=92924&highlight=range+lookup
viewtopic.php?t=93532&highlight=range+lookup
viewtopic.php?t=92113&highlight=range+lookup
there are more out there you only need to search for them
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Then sign up with your support provider for premium service; learn the true cost of urgency. We don't do "urgent". We're all volunteers.Need some urgent help Regarding Range Lookup..
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.