problem in null handling
Posted: Mon Dec 31, 2007 2:49 am
Hi
I am having a problem with null handling. My code in tranformer derivation is-
If In_Tfm_EmpId_Customer.TRAN_TYPE='EMPSALE' AND In_Tfm_EmpId_Customer.CUSTOMER<>' ' Then NullToValue(In_Tfm_EmpId_Customer.ASSOC_ID,' ') Else NullToValue(In_Tfm_EmpId_Customer.EMP_ID,' ')
But still I am getting null values.
Please help
Regards
Arnie
I am having a problem with null handling. My code in tranformer derivation is-
If In_Tfm_EmpId_Customer.TRAN_TYPE='EMPSALE' AND In_Tfm_EmpId_Customer.CUSTOMER<>' ' Then NullToValue(In_Tfm_EmpId_Customer.ASSOC_ID,' ') Else NullToValue(In_Tfm_EmpId_Customer.EMP_ID,' ')
But still I am getting null values.
Please help
Regards
Arnie