DB2 ENTERPRISE as Target

[rahulverma]

Hello Members,

In a parallel job i need to load(UPSERT) into a DB2 Enterprise target table wherein i need to propagate the "CurrentTimestamp" to a field LST_UPDT_DTTM(type= Timestamp). I have used a transformer wherein LST_UPDT_DTTM coloumn derivation is "CurrentTimestamp()"

The Fatal message in Director log is:
DB2_UDB_Enterprise_0,0: Error Idx = 12;
DB2Driver Embedded SQL message: SQL0180N The syntax of the string representation of a datetime value is
incorrect. SQLSTATE=22007
;
sqlcode = -180;
sqlstate = 22007
Execute failed


Please suggest solution for this.
Your prompt reply will be greatly appreciated.

[ETLJOB]

Just verify, whether the output format (date and time) of the function "CurrentTimestamp()" is matching with the timestamp format of the DB2 database field LST_UPDT_DTTM.