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
ODBC Look up
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
RK