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?
NULL vs EmptyString
Moderators: chulett, rschirm, roy
Re: NULL vs EmptyString
A little lost. A space? If there's a space then you don't have an empty anything.poorna_76 wrote:even though i see a space in the dataset, datastage does not recognise this a EmptyString.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: NULL vs EmptyString
Chulett,chulett wrote:A little lost. A space? If there's a space then you don't have an empty anything ...poorna_76 wrote:even though i see a space in the dataset, datastage does not recognise this a EmptyString.
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.