DSXchange

Hi

When trying to load data into MDM using MDM connector stage in datastage its throwing error EODBC:, unable to insert/update/delete member data. This is happening only with with attrval(null) attribute of memattr table. Please help. If the attrval attributes have values in them or if they are removed from memput its loading. Its happening only if attrval attributes from source have nulls in them.

Thanks in advance.

How are you specifying the null values?

Thanks for your reply

I have 10 attributes that load into attrval of memattr table.
Our Source is a file, usually we are getting nothing meaning empty for all these fields. I am sending the same.

Please let me know if you need further information in order to resolve my problem.

Appreciate your help.

Empty is not the same as null. You need some mechanism to convert your empty strings to "out of band null". You can research this in the IBM Knowledge Center.

Hi Ray

Thank you so much for your reply.

My source is nullable and target is not nullable. So my scenario falls under out of band to normal representation.Can you please explain with an example for my case since i dont have any default value to load as explained in IBM Knowledge center.

If there is no value for that attribute i should also send without anything.

Appreciate your help.

Thanks & Regards

An in-band null is simply a value that you choose that is legitimate for the domain (e.g. data type) but which cannot occur in your data. For example, if a field is Integer, but you know that the values are always non-negative, then you might represent null as -1, or -4294967296. So long as your representation is consistent, and documented so that users are aware that this is an exceptional value, all should be well.

ray.wurlod wrote:An in-band null is simply a value that you choose that is legitimate for the domain (e.g. data type) but which cannot occur in your data. For example, if a field is Integer, but you know that the val ...

Hi Ray..

Thanks for your response but unfortuntately i dont have access to premium content so i cannot read entire message.

You can sign up here.