DSXchange

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

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,

Or the Mother of All Posts on the subject here.

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

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

You always was Mom's favorite.

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.