Empty String handling in 8.7
Posted: Thu Aug 01, 2013 4:39 am
Hi,
We are migrating the code developed in datstage 8.1 to datastage 8.7 version. And observded that empty strng handling is not working correctly in 8.7 which worked fine in 8.1 verion of the code.
Job Design :
(TDCONN1) ---->> JOIN ---->> TFM ---->> TDCNN
........................... |
LEFT OUTER JOIN |
............................|
..................... (TDCONN2)
The condition in the transformer is
If (TDCONN2.col1)='' then -1 else TDCONN2.col1
Col1 is Nullable No in the database and We are getting an Empty Strying when the Left outer join incase match is not found. In 8.1, the output is value in -1 while in 8.7, the records are getting dropped.
If I am changing the derivations If IsNull(TDCONN2.col1) then -1 else TDCONN2.col1 , we get the exected result i.e -1 in 8.7
How we can fix this issue without making changes in all the 8.7 datastage jobs.
Regards
Neeraj
We are migrating the code developed in datstage 8.1 to datastage 8.7 version. And observded that empty strng handling is not working correctly in 8.7 which worked fine in 8.1 verion of the code.
Job Design :
(TDCONN1) ---->> JOIN ---->> TFM ---->> TDCNN
........................... |
LEFT OUTER JOIN |
............................|
..................... (TDCONN2)
The condition in the transformer is
If (TDCONN2.col1)='' then -1 else TDCONN2.col1
Col1 is Nullable No in the database and We are getting an Empty Strying when the Left outer join incase match is not found. In 8.1, the output is value in -1 while in 8.7, the records are getting dropped.
If I am changing the derivations If IsNull(TDCONN2.col1) then -1 else TDCONN2.col1 , we get the exected result i.e -1 in 8.7
How we can fix this issue without making changes in all the 8.7 datastage jobs.
Regards
Neeraj