This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How do i set null values into an Integer column in the native database connector

Hi All,

Version: 7.1.1

I am using the Native Database connector for DB2 and am trying to synchronise a NULL value into an Integer column in a DB2 database. 

Any ideas on how to do this?

Everything I've tried has resulted in the connector attempting to set the value to 0 which fails as the column is also a foreign key constraint (for which no record exists with a PK of 0).

 

Thanks