No errors in Talend but no data getting inserted into DB2

[Anonymous]

Hi Guys,

I have an ETL process that runs fine with no errors; and tDB2Output\tDB2Commit components show no errors and a row count of rows inserted,

However when I check the DB2 table I do not see any data there.

If I write to a flat file and then load that file to DB2, it works fine as is with no changes needed to the data.

Any ideas how to troubleshoot to see where the issue is.

Thanks!

[Anonymous]

Hi,

   Since you are using a subscription product, could you please raise a support case for this issue? You can give the details of the community link so that they don't have to start the details from scratch.

   They can do the verification using a webex session so that things will be quicker.

Warm Regards,

Nikhil Thampi

[FBoulet1617182137]

Hi,

It's a bit late but i had the exact same problem and i found the solution : your insert is not commit.

In my case i used a tDBConnection and my tDBOutput was set with "Use an existing connection".

To solve the problem, i had to check "Automatic commit" in advanced setting of my tDBConnection.

I hope it'll help

Regards,

Florian