Empty String handling in 8.7

[neeraj]

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

[SURA]

If I am right this should work.

Code: Select all

APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING

[devidotcom]

I am encountering the same issue.. the environment parameter mentioned is set to false in both 8.1 and 8.7.

Thanks.

[chulett]

I'm assuming the suggestion was to try setting it to True.