Hi All,
I was trying to load AS/400 DD2 date(YYYY-MM-DD) to SQLSERVER Database(Datetime) i am getting datetime overfolw error eventhough i used Oconv(Iconv,"D-YMD[4,2,2]),"D-YMD[4,2,2]").
ANy help...
Thanks,
Ram.
Date conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Jan 12, 2004 7:20 am
- Location: USA
Re: Date conversion
[quote="ksmurthys"]Hi All,
I was trying to load AS/400 DD2 date(YYYY-MM-DD) to SQLSERVER Database(Datetime) i am getting datetime overfolw error eventhough i used Oconv(Iconv,"D-YMD[4,2,2]),"D-YMD[4,2,2]").
ANy help...
Thanks,
Ram.[/quote]
Windoze EBCDIC conversion table has issues , You need to convert EBCDIC character to ASCII equivalent by using DataStage built-in EBCDIC function calls, this will solve your problem.
Alex
I was trying to load AS/400 DD2 date(YYYY-MM-DD) to SQLSERVER Database(Datetime) i am getting datetime overfolw error eventhough i used Oconv(Iconv,"D-YMD[4,2,2]),"D-YMD[4,2,2]").
ANy help...
Thanks,
Ram.[/quote]
Windoze EBCDIC conversion table has issues , You need to convert EBCDIC character to ASCII equivalent by using DataStage built-in EBCDIC function calls, this will solve your problem.
Alex