DB2 Output with Identity field.

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?

 

 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download