Character To Date Conversion
Posted: Wed Sep 24, 2008 12:18 am
Hi All,
My source file .txt having a date value and I'm trying to load it into the Teradata database. The teradata database having DATE column. In the transform the datastage job gets abort with error.
Job_10_TD_SBT_Load..Transform: At row 1, link "ToLoad", while processing column "Scn_Dt"
Value treated as NULL
Attempt to convert String value "2008-09-21" to Date type unsuccessful.
I used Oconv(ToTransform.Scn_Dt,"D-YMD[4,2,2]") function into the transformer.
Please help. Thanks
My source file .txt having a date value and I'm trying to load it into the Teradata database. The teradata database having DATE column. In the transform the datastage job gets abort with error.
Job_10_TD_SBT_Load..Transform: At row 1, link "ToLoad", while processing column "Scn_Dt"
Value treated as NULL
Attempt to convert String value "2008-09-21" to Date type unsuccessful.
I used Oconv(ToTransform.Scn_Dt,"D-YMD[4,2,2]") function into the transformer.
Please help. Thanks