DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Ansh1124
Participant



Joined: 17 Nov 2017
Posts: 9

Points: 75

Post Posted: Wed Dec 20, 2017 4:54 pm Reply with quote    Back to top    

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.

_________________
Ansh
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54397
Location: Sydney, Australia
Points: 295048

Post Posted: Wed Dec 20, 2017 5:14 pm Reply with quote    Back to top    

How are you specifying the null values?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
Ansh1124
Participant



Joined: 17 Nov 2017
Posts: 9

Points: 75

Post Posted: Wed Dec 20, 2017 5:34 pm Reply with quote    Back to top    

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.

_________________
Ansh
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54397
Location: Sydney, Australia
Points: 295048

Post Posted: Thu Dec 21, 2017 7:01 pm Reply with quote    Back to top    

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.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
Ansh1124
Participant



Joined: 17 Nov 2017
Posts: 9

Points: 75

Post Posted: Fri Dec 22, 2017 6:41 pm Reply with quote    Back to top    

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

_________________
Ansh
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54397
Location: Sydney, Australia
Points: 295048

Post Posted: Fri Dec 29, 2017 8:13 pm Reply with quote    Back to top    

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 ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
Ansh1124
Participant



Joined: 17 Nov 2017
Posts: 9

Points: 75

Post Posted: Sat Dec 30, 2017 12:04 am Reply with quote    Back to top    

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.

_________________
Ansh
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54397
Location: Sydney, Australia
Points: 295048

Post Posted: Mon Jan 01, 2018 3:53 am Reply with quote    Back to top    

You can sign up here.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours