Thanks chulett
Work around ..I meant here is to do with different format for date.
Now I have different format of string as
INPUT (Sequential file ) :YYYYMMDD VARCHAR 8
TARGET DB2:DATE (4)
Transformer function used :
Code: Select all
StringToDate(Input.column,"%yyyy%mm%dd")
Also I tried using Substring
Code: Select all
Inputlink.colname[1,4]:'-':Inputlink.colname[5,2]:'-':Inputlink.colname[7,2]
Code: Select all
Error :
APT_CombinedOperatorController,0: Conversion error calling conversion routine date_from_string data may have been lost
SQLExecute reported: SQLSTATE = 22007: Native Error Code = -180: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007
I am able to insert records for date fields manually in DB2 control in the format yyyy-mm-dd
I search this topic in the forum ..I was not able to fix this issue
.. :D
Thanks for the input