Replicat with where clause using timestamp field
Hi all,
I would like to know how can I use in my replicat file a where clause with timestamp datatype. I don't know why my where didn't work.
My source database is a DB2 v10 z/OS and my target database is oracle 11.2.0.4.18.
My replicat file:
replicat ilrdb2
END RUNTIME
SETENV (ORACLE_HOME="/oracle/product/11.2.0.4/db_1")
SETENV (ORACLE_SID="HOM11G")
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
USERID ggate, PASSWORD ggate
DISCARDFILE ./dirrpt/ilrdb2.dsc, Purge
MAP source.TESTDB2 , TARGET ggate.TESTDB2, where (dt_proc >= '01-JAN-16 00.00.00.00000 AM');
Thanks in advance