Illegal date/time value
Posted: Sun Oct 31, 2004 5:58 pm
Hi,
I am trying to insert date values into db2 table which is defined as date(10).
I tried using both ODBC & DB2UDB stage.
When i use ODBC stage, iam getting the following error:
Illegal date/time value DATE1 = '01/01/2004'
When i use DB2UDB stage, iam getting the following error:
"Value treated as NULL
Attempt to convert String value "01/01/2004" to Date type unsuccessful"
I am using folowing code to convert into db2 format:
OCONV(ICONV(linkname.DATE1,"DMDY"),"D4/MDY[2,2,4]")
Please help me out.
I am trying to insert date values into db2 table which is defined as date(10).
I tried using both ODBC & DB2UDB stage.
When i use ODBC stage, iam getting the following error:
Illegal date/time value DATE1 = '01/01/2004'
When i use DB2UDB stage, iam getting the following error:
"Value treated as NULL
Attempt to convert String value "01/01/2004" to Date type unsuccessful"
I am using folowing code to convert into db2 format:
OCONV(ICONV(linkname.DATE1,"DMDY"),"D4/MDY[2,2,4]")
Please help me out.