Hi
I am trying to do a simple lookup and it is not working.
My jOb design is like this:
ODBC1---->TX(llokup with another ODBC2)-->ODBC3
In ODBC1 , I am joining few tables. and based on the key columns obtained from it I am doing a lookup with the
key columns present in ODBC2 to pull out one column.
When I designed the joba nd ran it, it gets executed but no lookup is performed.
What might be the problem?
Lookup
Moderators: chulett, rschirm, roy
Re: Lookup
At a guess - your keys don't match. Are you sure that the fields match exactly?pradkumar wrote:Hi
In ODBC1 , I am joining few tables. and based on the key columns obtained from it I am doing a lookup with the
key columns present in ODBC2 to pull out one column.
When I designed the joba nd ran it, it gets executed but no lookup is performed.
What might be the problem?
More than likely you are wrong there and they in fact do NOT match. That is the most common problem when lookups 'fail' which is why Shane ask about it first.
Your other problem could be your lookup sql - is it generated or user defined? Do your keys match up properly with the positional parameter markers that ODBC uses?
Your other problem could be your lookup sql - is it generated or user defined? Do your keys match up properly with the positional parameter markers that ODBC uses?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: