TDP 3.8. Source is DB2 ZOS 10. Target is Oracle 18.104.22.168.
Data Compare, then Sync Data from Source to Target. The Wizard generates the Insert Statements, but it does not run and gets an error. It is due to the Time Stamp column format difference and the blank spaces, which makes the Insert Statements invalid. Also, the Date & Time is not in the Insert Statement.
If the Insert Statement is run as is, it will give the error:
ORA-00936: missing expression