Date conversion Error
Posted: Sun Apr 25, 2010 1:05 pm
Hi,
I have a source datacolumn seldate in the form of 99991231 coming from a flatfile. Length of this field is varchar 8
I have to insert that to DB2 table using a DB2 enterprise stage. I am following the steps below.
1 In the derivation of transformer stage I am using the following function.
StringToDate(incolumn,'%yyyy%mm%dd') and My target column datatype is Date....
Everything fine...I am getting output also but the issue is I am getting a disturbing warning though I think I did all right.. Please can anyone tell me what is the reason for this warning.
APT_CombinedOperatorController(0),0: Conversion error calling conversion routine date_from_string data may have been lost
I have a source datacolumn seldate in the form of 99991231 coming from a flatfile. Length of this field is varchar 8
I have to insert that to DB2 table using a DB2 enterprise stage. I am following the steps below.
1 In the derivation of transformer stage I am using the following function.
StringToDate(incolumn,'%yyyy%mm%dd') and My target column datatype is Date....
Everything fine...I am getting output also but the issue is I am getting a disturbing warning though I think I did all right.. Please can anyone tell me what is the reason for this warning.
APT_CombinedOperatorController(0),0: Conversion error calling conversion routine date_from_string data may have been lost