ODBC Look up

g_rkrish · Post by **g_rkrish** » Tue Apr 11, 2006 2:18 pm

Hi,

i am trying to look up a table.when i try running that table what it does is it puts the first row value to all the rows not matter lookup found or not found.

when i do the same thing using hash file it works.It looks weired.i tried running the query it works fine in the database.

Can any one help me out in this?

thanks,
RK

kcbland · Post by **kcbland** » Tue Apr 11, 2006 2:45 pm

Did you define the key values used in the WHERE clause on the reference stage?

us1aslam1us · Post by **us1aslam1us** » Tue Apr 11, 2006 4:24 pm

It is related to keys in the WHERE clause,just define the key=? when using a user defined SQL.

Thanks
sam

chulett · Post by **chulett** » Tue Apr 11, 2006 5:06 pm

I've found you can't rely on the NOTFOUND link variables for anything other than hashed file lookups. Using them with a database stage is asking for trouble. Fall back on the old fashioned 'check a key field for null' techinque to see if the lookup failed.

g_rkrish · Post by **g_rkrish** » Tue Apr 11, 2006 5:59 pm

kcbland wrote:Did you define the key values used in the WHERE clause on the reference stage? ...

thanks,

It works,

I think the real problem was i gave a user defined query.but ideinfed the key column in the ODBC stage but i didn't specify in the reference so it was causing me that problem.

thank you everybody for the help.

RK