hi all,
i am changing the datatype of my input column timestamp to string,it is generated error like;
xfmLoadData,0: Conversion error calling conversion routine timestamp_from_string data may have been lost
can u provide the solution...
thanks inadvance
praveen
warnings when changing the data type
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi Praveen,
In which stage you are performing this converison either Transformer or Modify stage. Use the Proper syntax for that in the above stages. If you are perfoming this in any satge without any conversion, then it will throw error to you.
In Tarnsformer :
TimestampToString Return the string representation
of the given timestamp
timestamp[format (string)] result (string)
In Modify Stage :
stringField = string_from_timestamp
[timestamp_format | uformat](tsField)
Hope It will Help.
In which stage you are performing this converison either Transformer or Modify stage. Use the Proper syntax for that in the above stages. If you are perfoming this in any satge without any conversion, then it will throw error to you.
In Tarnsformer :
TimestampToString Return the string representation
of the given timestamp
timestamp[format (string)] result (string)
In Modify Stage :
stringField = string_from_timestamp
[timestamp_format | uformat](tsField)
Hope It will Help.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
hi nagesh,Nageshsunkoji wrote:Hi Praveen,
In which stage you are performing this converison either Transformer or Modify stage. Use the Proper syntax for that in the above stages. If you are perfoming this in any satge without any conversion, then it will throw error to you.
In Tarnsformer :
TimestampToString Return the string representation
of the given timestamp
timestamp[format (string)] result (string)
In Modify Stage :
stringField = string_from_timestamp
[timestamp_format | uformat](tsField)
Hope It will Help.
i am using at transformer stage ,conversion function is timestampTostring function i am using,i got warnings like
1)xfmLoadData,3: Conversion error calling conversion routine timestamp_from_string data may have been lost
2)xfmLoadData,2: Conversion error calling conversion routine timestamp_from_string data may have been lost
3)xfmLoadData,1: Conversion error calling conversion routine timestamp_from_string data may have been lost
these three warnings only and i am getting the output data perfect.
what is the problem in this...can u find.
thanks inadvance
praveen
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am