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
Error with Date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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...
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...
ray.wurlod wrote:You start by informing us what the target database is, and what its expected date format is. Then you adjust your value accordingly. ...
Use function to convert it into db2 date format.
Code: Select all
Oconv((Iconv(Arg1,"D-YMD")),"D-YMD[4,2,2]")
Where Arg1= COLL_DTrafik2k wrote:Usefunction to convert it into db2 date format.Code: Select all
Oconv((Iconv(Arg1,"D-YMD")),"D-YMD[4,2,2]")
Re: Error with Date
thanks guys
cosec wrote: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