Error loading Timestamp to DB2 from Oracle DB

[amarjpn]

We are facing an issue with the loading of Timestamp field from Oracle Db to DB2 database. I think in oracle we store the timestamp in 26 bytes but when we are trying to load this field to DB2, we are getting error. The issue is in DB2 database timestamp is of 10 bytes and in oracle it is 26 bytes.

Can anyone help me how can I load the 26 byte timestamp field to DB2 database?

[shawn.k]

I never worked with DB2 before so I am not sure whether you are trying to store Timestamp(26) into Date (10 bytes). I might be wrong too, but if you are doing this than use Timestamp to date function. Let me know if this helped.

[DSguru2B]

10 bytes is not a timestamp. Its a date field. Convert your data into date and try inserting.