Could you please print the current format of timestamp you are getting from Talend?
Also could you please share the timestamp format which your DB2 code is expecting? Once these two details are available, we can convert the value to desired format as String data type. While loading to DB2, you can convert this string to timestamp within DB2 using DB2 functions.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)
Sorry for the delay...
Today, I use the following workaround... I define the mapping DB for the schema to "String" and I format the value with a timestamp format that DB2 understand. In this case, I can import the data.
But my first question is still : How I can force Talend to use "setTimestamp" in place of "setDate" when I define in my schema the date type ?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.