Page 1 of 1
Nulls appear for business key columns on SCD Type1 update
Posted: Wed Oct 01, 2008 3:13 am
by RudreshEswarappa
Hi,
I am using SCD stage to do type 1 updates on a particular table.The business key field is of type varchar. When changes on the attribute takes place instead of update a new row is inserted but with business key value NULL.
I tried changing the datatype from varchar to integer (since value were compatible for datatype change) and the type1 update was successful. but now i have a table with values that cannot be integer and I cannot find any workaround.
Can anyone help?
Thanks in advance.
Regards
Posted: Wed Oct 01, 2008 3:28 am
by ray.wurlod
I wonder if this is related to the known bug in which range lookups work for numeric data types but not for string data types?
Alas I can't help with a solution.
Posted: Wed Oct 01, 2008 3:45 am
by RudreshEswarappa
Thanks for the response Ray.
What do you suggest... Shall I take it up with the support then? this is something That has to be implimented ASAP...
Can you suggest any workaround.
Posted: Wed Oct 01, 2008 5:58 am
by ray.wurlod
If it's urgent why are you waiting for my advice? You are paying your support provider; let them earn some of it.
Posted: Thu Oct 16, 2008 6:27 am
by platonfi
Support has a client side patch for this known issue.
Posted: Fri Jul 17, 2009 8:01 am
by algfr
Hello
I think I have this issue, it is a HUGE problem.
I have DS 8.01 FP1a
Could you tell me if this version has the issue or not ? I can't find it on the IBM site.
Posted: Fri Jul 17, 2009 8:08 am
by algfr
It is a client patch not a server patch ?
Posted: Mon Jul 20, 2009 2:18 am
by algfr
Nobody has a clue ?
It really surprises me as this bug seems huge (no way to lookup on a varchar)...
I've opened a case at IBM so I'll let you know.
Posted: Tue Jul 28, 2009 5:59 am
by algfr
IBM says : Appears to be the patch_JR30746v2_client_windows_801fp1.zip on the client side. Don't know if that works yet. It's weird to me a patch can be on the client side...
Posted: Tue Jul 28, 2009 8:01 am
by chulett
From what I've seen, most patches for 8.x are applied from the client side, that doesn't necessarily make them a 'client patch' however.
Posted: Thu Jul 30, 2009 9:57 am
by algfr
So far not resolved yet, I'm still communicating with IBM, it's strange other people didn't have thsi problem that much.
Anyway I'll let you know
Posted: Fri Aug 07, 2009 1:58 am
by algfr
algfr wrote:So far not resolved yet, I'm still communicating with IBM, it's strange other people didn't have thsi problem that much.
Anyway I'll let you know
Ok, this is the correct patch, this works now.