I am facing some strange issue in Datastage 8.5.
When I compare two 'BLANK' i.e string only. it is always returning false.
say for example,
Code: Select all
(If isnull(LkpEmp_Src_Fld)
then 'BLANK' else Emp_Src_Fld )
dataset---->Transformer ----------------------->Lookup stage -------> dataset
('BLANK' --> Emp_Src_Fld) ^
|
seq_file
Assume, Lkp_Src_Fld wwill have both 'BLANK' and some values. There is no space inSIDE THE STRING.
If both are 'BLANK', I will have to return 'NIL-ACCOUNT'. Eventhough both side contain 'BLANK' value , i am not getting the expected result. why? is there any setting needs to be changed? is 'BLANK' reserved word in datastage? I think 'No'.
Inputs are welcome!