Hi,
I have developed a job(Seq file -> Transformer -> Oracle) form Seq file I am pulling the date column values(Some values are null also) which are Varchar data type and in transformer I am using the StringToDate function to convert these Varchar into Date type. When I am running this job I am getting the below warning.
APT_CombinedOperatorController,0: Conversion error calling conversion routine date_from_string data may have been lost
Please let me know what might be the reason and how we can eliminate this warning
Thanks in Advance
Regards
Sridhar
Getting warning as Conversion error routine date_from_string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Well..
you have to verify the contents of the particular field before perform the actual conversion.
you should do something like below
Edi
you have to verify the contents of the particular field before perform the actual conversion.
you should do something like below
Code: Select all
If Trim(date column)='' then SetNull() else StringToDate(date column)