Hi All,
Could some one help me how to get rid of this warning message.
My input is a reading from a sequential file and loading to a DB2 table.
Input has a field with type of Varchar(8) and Target field type of Date(10).
When I do a StringToData(<FieldName>,"%YYYY-%MM-%DD") iam getting the following warning message.
Transformer_2,0: Conversion error calling conversion routine date_from_ustring data may have been lost.
Thanks in advance
Best regards
Cherry
date_from_ustring
Moderators: chulett, rschirm, roy
Re: date_from_ustring
Try this Function:
UstringToString(StringToData(<FieldName>,"%YYYY-%MM-%DD"))
UstringToString(StringToData(<FieldName>,"%YYYY-%MM-%DD"))
Your picture for the conversion has 10 characters, but your string only holds 8.
p.s. please delete your duplicate post before someone responds to it.
p.s. please delete your duplicate post before someone responds to it.
Last edited by ArndW on Wed Jan 20, 2010 4:22 am, edited 1 time in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
you have created 2 post and replied to one in 5 minutes.
people reply when they can and if they can. Please delete your other post.
You might have two scenarios
1. You are handling nulls incorrectly.
2. The date string doesn't match the format picture, as mentioned by Arnd.
a search would have revealed the required information you are searchin for.
people reply when they can and if they can. Please delete your other post.
You might have two scenarios
1. You are handling nulls incorrectly.
2. The date string doesn't match the format picture, as mentioned by Arnd.
a search would have revealed the required information you are searchin for.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.