To map the column to the current systimestamp of the database operation
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")