I'm using Datastage 7.5.1
I was doing a lookup on a filed which has values like 'TCSCLINTGRPID6' on both the master & reference.
It is a varchar field of length 15.
But i was not getting a hit.
Awaiting for ur help in this regard.
Lookup Not Happening
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India
Lookup Not Happening
Regards
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2007 1:58 am
- Location: India
[quote="ray.wurlod"]Ur was a city in ancient Babylonia - the second person possessive pronoun is spelled "your".
Are the two fields identically trimmed? ...[/qu
Both these fields are from db2 source.
Both these fields are identically trimmed in the extract query itself like LTRIM(RTRIM(Field)).
As well as these fields are trimmed in the previous jobs before this lookup job in the transformer stage by using trimleadingtrailing() funtion.
When i view the datsets(both master & reference),i didn't find any spaces in between,both the values seems to be identical.
then what might be the possibility.
Even i tred using APT_PAD_CHAR environment variable in my job.
But Even that was not working.
I tried using join & merge,both these stages doesn't find any hit.
But if try joining these tables by using a simple join query,I was getting a valid hit.(Query returns valid values).
What might be the problem?
Does it is a problem with the datastage ?!
Are the two fields identically trimmed? ...[/qu
Both these fields are from db2 source.
Both these fields are identically trimmed in the extract query itself like LTRIM(RTRIM(Field)).
As well as these fields are trimmed in the previous jobs before this lookup job in the transformer stage by using trimleadingtrailing() funtion.
When i view the datsets(both master & reference),i didn't find any spaces in between,both the values seems to be identical.
then what might be the possibility.
Even i tred using APT_PAD_CHAR environment variable in my job.
But Even that was not working.
I tried using join & merge,both these stages doesn't find any hit.
But if try joining these tables by using a simple join query,I was getting a valid hit.(Query returns valid values).
What might be the problem?
Does it is a problem with the datastage ?!
Regards
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 43
- Joined: Wed Oct 18, 2006 6:03 am
I think I have the same problem.
I'm doing a lookup on a table in a DB2 database. The field that I'm trying to do the lookup with is a varchar(16) and the data is '111222333'(9 characters). It fails.
If I hardcode the data in the previous transformer it works. (Not using the DSLink.xxxxx input.)
If I change the input field from 16 to 9 characters, the same length as the data, it works. The table still has 16 characters in the field.
I want it to match and still have 16 characters in the input field since there will be diffrent lengths of the data in the future.
I tried all the diffrent trim() functions without any luck.
I'm using DS 8.
(not sure if it's ok to highjack a thread, but since it's the same topic)
/Mattias
I'm doing a lookup on a table in a DB2 database. The field that I'm trying to do the lookup with is a varchar(16) and the data is '111222333'(9 characters). It fails.
If I hardcode the data in the previous transformer it works. (Not using the DSLink.xxxxx input.)
If I change the input field from 16 to 9 characters, the same length as the data, it works. The table still has 16 characters in the field.
I want it to match and still have 16 characters in the input field since there will be diffrent lengths of the data in the future.
I tried all the diffrent trim() functions without any luck.
I'm using DS 8.
(not sure if it's ok to highjack a thread, but since it's the same topic)
/Mattias