GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Replicat with where clause using timestamp field

edited Aug 17, 2018 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center