lookup generating null string
Posted: Thu Feb 16, 2006 9:12 pm
Hi All,
I have a problem with the values returned by a lookup. My field is defined as Char (1) and some of the values are not matched. I have set the lookup to continue in this case. My understanding is that the value returned by the lookup will be set to null when no match was made.
However, the lookup seems to return an unindentified value. When I try to use the function IsNull(Value) in a transformer, it returns false. The test Trim(Value) = '' will also return false. But when I try AlNum(Value) the function fails telling me that a null string is being passed to the function???
When I dump the result in a flat file, I see that the value for the unmatched field is unreadable in ascii but correponds to the Hex value 0x00. This should be a Null, shouldn't it?
Any ideas how DataStage might interpret this field?
Thanks,
Mat
I have a problem with the values returned by a lookup. My field is defined as Char (1) and some of the values are not matched. I have set the lookup to continue in this case. My understanding is that the value returned by the lookup will be set to null when no match was made.
However, the lookup seems to return an unindentified value. When I try to use the function IsNull(Value) in a transformer, it returns false. The test Trim(Value) = '' will also return false. But when I try AlNum(Value) the function fails telling me that a null string is being passed to the function???
When I dump the result in a flat file, I see that the value for the unmatched field is unreadable in ascii but correponds to the Hex value 0x00. This should be a Null, shouldn't it?
Any ideas how DataStage might interpret this field?
Thanks,
Mat