String compare
Posted: Thu Feb 21, 2008 10:51 am
Hi,
In a transform job, I try to compare 2 stage variables containing a string value. Here are an exemple of my problem...
The first variable value is : "00E019"
The second variable value is : "00E017"
The problem is that the following verification : If Var1 = Var2
return always true. The reason is because DataStage is taking the "e" as a Exponent.
I don't want a mathematical compare between this 2 strings but a real string compare.
Can some one help me on this one.
Thanks.
In a transform job, I try to compare 2 stage variables containing a string value. Here are an exemple of my problem...
The first variable value is : "00E019"
The second variable value is : "00E017"
The problem is that the following verification : If Var1 = Var2
return always true. The reason is because DataStage is taking the "e" as a Exponent.
I don't want a mathematical compare between this 2 strings but a real string compare.
Can some one help me on this one.
Thanks.