Lookup

[pradkumar]

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?

[ShaneMuir]

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?

At a guess - your keys don't match. Are you sure that the fields match exactly?

[pradkumar]

They DO match

[ShaneMuir]

They DO match

Just looking for the obvious solution first - so there are no extra spaces in either table, non printing characters etc?

[chulett]

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?

[ray.wurlod]

What are the data types of the reference key and the parent key?