Error with Date

[cosec]

I have a date field of the YYYY-MM-DD in a sequential file...When I load to the target table I am having an error as follows...

how do i fix this

LD_RMM_COLL_BAT..TRX_RMM_COLL_BAT_1: At row 113, link "Output", while processing column "COLL_DT"
Value treated as NULL
Attempt to convert String value "2007-05-23" to Date type unsuccessful

[ray.wurlod]

You start by informing us what the target database is, and what its expected date format is. Then you adjust your value accordingly.

[cosec]

expected date format YYYY-MM-DD
Target database : DB2

sequential file is of the form YYYY-MM-DD but when i run the job i get the error specified in the earlier message...

You start by informing us what the target database is, and what its expected date format is. Then you adjust your value accordingly. ...

[rafik2k]

Use

Code: Select all

Oconv((Iconv(Arg1,"D-YMD")),"D-YMD[4,2,2]")

function to convert it into db2 date format.

[rafik2k]

Use

Code: Select all

Oconv((Iconv(Arg1,"D-YMD")),"D-YMD[4,2,2]")

function to convert it into db2 date format.

Where Arg1= COLL_DT

[cosec]

thanks guys

I have a date field of the YYYY-MM-DD in a sequential file...When I load to the target table I am having an error as follows...

how do i fix this

LD_RMM_COLL_BAT..TRX_RMM_COLL_BAT_1: At row 113, link "Output", while processing column "COLL_DT"
Value treated as NULL
Attempt to convert String value "2007-05-23" to Date type unsuccessful

[DSguru2B]

As far as I remember, if its just date "DATE(10)", then db2 accepts it in internal format. If you just sent it as ICONV() it will accept it.