Hi,
I am having a problem in String to date conversion in transformer stage.There I have put a peek stage and found that the date field is getting converted to ********. And the warning that I have got is:
APT_CombinedOperationComtroller(1),1:Conversion error calling conversion routine date_from_string data may have been lost.
The field id TRAN_DATE varchar(unicode) 10.
Please suggest any solution.
Regards
Arnie.
Problem with String to date conversion
Moderators: chulett, rschirm, roy
-
arnie_nits
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Point 1: diagnosis is nearly impossible while operator combination is in effect. Lose it.
Point 2: why Unicode?
Point 3: what is the format of TRAN_DATE, and what is the format string in your date_from_string() function?
Point 2: why Unicode?
Point 3: what is the format of TRAN_DATE, and what is the format string in your date_from_string() function?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
arnie_nits
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 am
Its coming as unicode from the database............ray.wurlod wrote:Point 1: diagnosis is nearly impossible while operator combination is in effect. Lose it.
Point 2: why Unicode?
Point 3: what is the format of TRAN_DATE, and what is the format string in your d ...
Its format is yyyy-mm-dd..........