topic Re: Updating a DB2 Table which has AUTO INCREMENT in Talend Studio

Updating a DB2 Table which has AUTO INCREMENT

Anonymous — Tue, 29 Jan 2019 09:11:07 GMT

Hello,

I have a DB2 table, which has been created with the option:

"E_SID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1),

PRIMARY KEY (E_SID)

Now I want to update some field by using tMap. Since it's an update I need to define the key field in the target table. The problem is when I do that, I get an error from the DB2 database saying, that the target field can not be written manually, since it has been declared with auto increment. If I would remove the this field, the update cannot be made, because of the missing key field. Do I have to remove the auto increment from the table to be able to do an update?

Re: Updating a DB2 Table which has AUTO INCREMENT

vapukov — Tue, 29 Jan 2019 09:35:51 GMT

Hi,

did you try in advanced settings of output component, select use field option and uncheck updatable, like this:

Re: Updating a DB2 Table which has AUTO INCREMENT

Anonymous — Tue, 29 Jan 2019 09:41:29 GMT

Thanks for the advice @vapukov

I was not aware of this option. But in this case I had another problem in another output component. I was just looking at the wrong place. If the update is set up as in my example, it now works as designed.

Thanks!

Re: Updating a DB2 Table which has AUTO INCREMENT

vapukov — Tue, 29 Jan 2019 09:44:35 GMT

ok,

this settings independent for each component (and for insert/update), so must be no collisions, but if it work is good

Re: Updating a DB2 Table which has AUTO INCREMENT

Anonymous — Tue, 29 Jan 2019 09:46:20 GMT

Yes, you are absolutely right! Thanks for sharing 😃