Hi,
In a SQL-to-DB2 scenario, I got an Duplicate key error when executing the UPDATE updategram. But it should be an error that a INSERT updategram should get. So I bet I’m doing something wrong here. Someone please point out the mistake of what I did in source schema generation at DB2 side and mapping.
<Source Schema Generation at SQL side>
-generated a schema with a select statement
let’s say it’s
-A (PK)
-B
-C
<Source Schema Generation at DB2 side>
-chose updategram
-chose update
-chose a taple
-selected the PK field and some of the fields that i needed
let’s ay it’s
before
-A (PK)
-B
-C
after
-A (PK)
-B
-C
<Mapping>
I mapped everything in SQL schema to after section of DB2 schema.
Help really needed..thanks in advance.
Regards, Steve