Range lookup

him121 · Post by **him121** » Sun Aug 21, 2005 10:50 pm

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

roy · Post by **roy** » Mon Aug 22, 2005 1:53 am

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,

chulett · Post by **chulett** » Mon Aug 22, 2005 6:51 am

Or the Mother of All Posts on the subject here.

kduke · Post by **kduke** » Mon Aug 22, 2005 6:57 am

You had to bring in Mom into it. Didn't you?

chulett · Post by **chulett** » Mon Aug 22, 2005 7:03 am

I told you to stop picking on me or I would tell!

kduke · Post by **kduke** » Mon Aug 22, 2005 4:22 pm

You always was Mom's favorite.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 22, 2005 6:02 pm

Need some urgent help Regarding Range Lookup..

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.