19 Length numeric characters in constraints section
Posted: Mon Jan 31, 2005 9:21 am
Hi,
I'm having a serious problem. In my guess, this one could be a big issue in DataStage. I want you to make a sample job and test as I describe below, if you can.
There are two data '1234567890123456789' and '1234567890123456788'.
These two data are both character types (VARCHAR 25 lengths). Only one difference between two data is the last(19th) character.
I will assume the first string as "ID1" and the other one as "ID2".
I put a constraint in the transformer like this [ ID1 <> ID2 ].
In general, the result should be TRUE. But it was opposite, FALSE.
I really want to know the reason and the resolution.
Thank you.
I'm having a serious problem. In my guess, this one could be a big issue in DataStage. I want you to make a sample job and test as I describe below, if you can.
There are two data '1234567890123456789' and '1234567890123456788'.
These two data are both character types (VARCHAR 25 lengths). Only one difference between two data is the last(19th) character.
I will assume the first string as "ID1" and the other one as "ID2".
I put a constraint in the transformer like this [ ID1 <> ID2 ].
In general, the result should be TRUE. But it was opposite, FALSE.
I really want to know the reason and the resolution.
Thank you.