Problem with db2 date

[ravij]

Hi,

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

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

Please help to solve this problem.

[chulett]

I've tried to help. Twice now. Perhaps third time is the charm - leave the date in internal format and sent that to the DB2 stage.

[ravij]

Thanks Chulett,

I got the solution.. able to load the date into db2.

[DSguru2B]

Chulett, you were right, third time was the charm