Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
I’m using Integration server 4.6 with the jdbc adapter. I’m trying to insert null values into date columns in an Oracle database. When using the trace log tool, I can see that the date fields have values of “” before insertion. When I query the data base after the insert, the date columns have a value of ‘01-Jan-1900’ instead of null.
Thanks for your help
Check the table script in your DB whether you have set the DEFAULT value for that particular column to ‘01-Jan-1900’. Or check if there is any trigger written on that table to do so if the value is coming as NULL. Hope this helps!