DB2 Output with Identity field.

Highlighted
Six Stars

DB2 Output with Identity field.

Hi Team,

I want to read data from one schema and insert into another schema.

Both Source and target tables are already created on both schema.

I am just passing the table name one by one and by using Dynamic datatype reading data from source table and inserting into the target table. Its working fine with table does not have Identity field but I am facing issue if Table have Identity field with auto generated value.

Please suggest me the solution for this issue.

 

I know SQLServer output component having the property for "Turn On Identity Insert" but DB2 output component does not have any such property, please suggest.

 

Regards

Rahul N

Employee

Re: DB2 Output with Identity field.

Hi Rahul,

 

      Could you please verify whether the identity columns yo have configured in DB2 is having GENERATED ALWAYS clause or is it having GENERATED BY DEFAULT?

 

      If it is not having GENERATED ALWAYS clause, could you please reconfigure the DB2 table to GENERATED ALWAYS clause and give it a try?

 

Warm Regards,

Nikhil Thampi

Six Stars

Re: DB2 Output with Identity field.

Hi Nikhil,

 

Thanks for your reply.

I have verified that the Identity column have configured with GENERATED ALWAYS clause itself and I am not able to insert rows through Talend tDB2Output component. Please suggest if you have any other solution.

 

Regards

Rahul N

Six Stars

Re: DB2 Output with Identity field.

Can anyone help me on this topic?

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog