Updategram "UPDATE" not working

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Updategram "UPDATE" not working

Viewing 0 reply threads
  • Author
    Posts
    • #24450

      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

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.