I have a column of char(8)(format is like : DDMMYYYY) coming from Seq file and I need to convert it into Date(Date format is: YYYY-MM-DD) and load into DB2 db. When I tried convert the src column into internal format using Iconv in Trnsf stage and used Oconv in another Trnsf stage and load it into db its failed.
In Icov I used Like: Iconv(in.date,"DDMY") and
In Oconv I used like: Oconv(in.date,"D-YMD[4,2,2]")
I am getting the error like:
CopyOfSFIPFactFncChkRetAnl21..Copy_of_trns_ChkRetanl: MSR_PRD_ID = 12007 SRO_ID = 1 OPR_ID = 31 SRC_STM_ID = 2 CHK_RET_DT = NULL CHK_RET_AMT = 3 CHK_RET_VAL = 13936.10
Please help to solve this problem.CopyOfSFIPFactFncChkRetAnl21..Copy_of_trns_ChkRetanl: [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=55, TABLEID=8, COLNO=4" is not allowed. SQLSTATE=23502