Code: Select all
modify(0),0: Un-handled conversion error on field "DT_DEB_SITUATION " from source type "timestamp[microseconds]" to destination type "string[20]":
source value="2013-01-01 00:00:00.000000"; the result is non-nullable and there is no handle_null to specify a default value.
Code: Select all
Data set "/DVT/data/PIL_QPT_DCB/COMMON_DTM/DATASET/Ds_T_CNTC_TJ_ROLE_PRSM_CNTC_01_LAST_IMAGE.ds":
record
( CLE_DECIBEL: int64;
.
.
DT_DEB_SITUATION: timestamp[microseconds];
DT_FIN_SITUATION: nullable timestamp[microseconds];
)
Code: Select all
modify '
CLE_JOB:STRING=CLE_DECIBEL;
CLE_DECIBEL=CLE_DECIBEL;
DT_DEB_SITUATION: string[20]=string_from_timestamp[%yyyy-%mm-%dd %hh-%nn-%ss.6](DT_DEB_SITUATION)
NOWARN
Additionally, if I specify
Code: Select all
DT_DEB_SITUATION: nullable string[20]=string_from_timestamp[%yyyy-%mm-%dd %hh-%nn-%ss.6]
How can I additionally specify handle_null in the same specification or get Datastage to understand the original value is not nullable.