DSXchange

Posted: **Thu Sep 06, 2012 2:51 am**

All,

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

I will compare If Emp_src_Fld = Lkp_Src_Fld Then 'NIL-ACCOUNT'

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!

Posted: **Thu Sep 06, 2012 2:55 am**

I am sorry but I cannot make heads or tails from your text-graphic, the forum software didn't preserve any formatting.

"BLANK" as string contents is not a reserved word, and "BLANK" should be equal to "BLANK" as you assume.

I suggest you add another output link to a peek stage showing the contents of both strings to see what the actual values are.

DSXchange

Two BLANKS are equal ?

Two BLANKS are equal ?