NULL vs EmptyString

[poorna_76]

We are reading data from XML file using XML Stage and loading into dataset.
In the XML stage specified the option 'Replace NULL's with EmptyValues & Replace EmptyValues with NULL's'

For 'MissingAttributes' in the XML file, we are getting NULL's in the dataset.
For EmptyString's (Code ='') we are getting EmptyString in the dataset.

Now the problem, we are facing is:

When we are processing the datasets, we were able to identify 'MissingAttributes' by IsNull() check,but we were not able to do the EmptyString check.


If IsNull(linkName.ColumnName) - works perfectly fine.
If (LinkName.ColumnName = '' OR LinkName.ColumnName = "") - does not work at all . even though i see a space in the dataset, datastage does not recognise this a EmptyString.

what could be the issue?

[chulett]

even though i see a space in the dataset, datastage does not recognise this a EmptyString.

A little lost. A space? If there's a space then you don't have an empty anything.

[umamahes]

Then compare with space like below.
If (LinkName.ColumnName = " ") Then ... Else ..

Thanks

[poorna_76]

even though i see a space in the dataset, datastage does not recognise this a EmptyString.

A little lost. A space? If there's a space then you don't have an empty anything ...

Chulett,

Sorry for the confusion.
I don't see a space , i see it as empty string without any spaces.
Even if i do the Len(LinkName.ColumnName) i am getting the max length defined for that field as opposed to '0'.

For NULL's , i see as 'NULL' in the dataset without any issue.


Any help is greatly appreciated.