Hi All,
Am using a derivation as show below for a TIMESTAMP field and getting the error bInvalidDateTime has value 1 because the Field164 is empty in some instance and the job is trying to insert a ' ' to the TIMESTAMP and aborts
If
IsNotNull(LNK_READ.Field164)
Then
StringtoTimeStamp((Trim(LNK_READ.Field164):' ':Trim(LNK_READ.Field165)),"%yyyy/%mm/%dd %hh:%nn:%ss")
Else
SetNull()
Am unable to use IsNotNull and TRIM(Field164) <> '' as am getting the error as shown in the below link.
http://www-01.ibm.com/support/docview.w ... wg21444564
Please guide me on the issue, I tried to trim the complete derivation but still couldn't remove the error
bInvalidDateTime has value 1 - Empty Values
Moderators: chulett, rschirm, roy