GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

To map the column to the current systimestamp of the database operation

edited Mar 10, 2015 3:15PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered

Hi,

I need to map the GG_OPERATION_TIMESTAMP column to the current systimestamp of the database operation.   So I used below map statement with @DATENOW  function,  but it is not updating the "GG_OPERATION_TIMESTAMP"  in systimestamp format.  Since @DATENOW function returns the current date and time in the format YYYY-MM-DD HH:MI:SS  and not in systimestamp format,  please let me know if we have any other method to map the column in systimestamp format. 

Your early response is very much appreciated. 

MAP TLMPX_DBO.ACGR, TARGET GGAPP.TLM_CUS_ACGR,

COLMAP (USEDEFAULTS, GG_OPERATION = @case( @token ("TKN-OP-TYPE"), "INSERT", "I", "UPDATE", "U", "DELETE", "D", "SQL COMPUPDATE", "U", "FieldComp" , "U", "GGSPKUpdate", "U", "PK UPDATE", "U")

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