Return
-
Title
Data Compare | Sync Script | Insert Statements gets Lookup Error ORA-00936 error due to invalid Date & Time Stamp. -
Description
TDP 3.8. Source is DB2 ZOS 10. Target is Oracle 11.2.0.4.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:Lookup ErrorORA-00936: missing expression
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.