Merge
Moderators: chulett, rschirm, roy
Merge
hi all,
I am getting the following warning when am trying to merge the data using Merge stage.
"Value treated as NULL
Attempt to convert String value "R" to Time stamp type unsuccessful"
Am getting the output correctly but still getting the warning like this. I don know why its throwing like that. But i've followed a work around and also i might not be sure whether that work around is advisable to do or not. So Ds Gurus pls. help me to resolve this.
Let me explain the work around
Before merging the data i've changed the Time stamp data type into Character and after merging i've changed the character type into timestamp data type. After doing like this i didn come with warning i've said above.
And am not pretty clear that whether this is work around or not. because it may be the rule/way to merge the date fields. If so, pls. pls. excuse.
I am getting the following warning when am trying to merge the data using Merge stage.
"Value treated as NULL
Attempt to convert String value "R" to Time stamp type unsuccessful"
Am getting the output correctly but still getting the warning like this. I don know why its throwing like that. But i've followed a work around and also i might not be sure whether that work around is advisable to do or not. So Ds Gurus pls. help me to resolve this.
Let me explain the work around
Before merging the data i've changed the Time stamp data type into Character and after merging i've changed the character type into timestamp data type. After doing like this i didn come with warning i've said above.
And am not pretty clear that whether this is work around or not. because it may be the rule/way to merge the date fields. If so, pls. pls. excuse.
Thanks in advance...
veera...
veera...
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
What is the meaning of the value 'R' in your field? You are trying to convert this value into a timestamp. So you need to put in the rule to handle this value before passing it on to the target stage as a timestamp.
For instance you might decide to filter out all records with the value R in this field or whatever.
You decide. You code accordingly. DS can't do that for you.
For instance you might decide to filter out all records with the value R in this field or whatever.
You decide. You code accordingly. DS can't do that for you.
Nope!!!!!!!!!!! there is no such R in the field. But still its showing the warning. I would've done that before asking this question in forum if R was present in the column. Thanks.John Smith wrote:What is the meaning of the value 'R' in your field? You are trying to convert this value into a timestamp. So you need to put in the rule to handle this value before passing it on to the target stage as a timestamp.
For instance you might decide to filter out all records with the value R in this field or whatever.
You decide. You code accordingly. DS can't do that for you.
Thanks in advance...
veera...
veera...
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
OK, we're not getting enough from the error message alone. Somewhere, perhaps in your source data, there is a value "R" that is not being successfully converted to a timestamp. Can you please therefore post (a) your job design and (b) the column definitions of your source data?
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.
No ray when am trying to view the data at th output, i can see the data properly. I dont know why the log is coming. Am damn sure that there is no such R character in the source field value. But still am facing the same error. that is why am asking whether merge stage will allow timestamp field to merge or should we change that into char field and then merge?.. the later one got worked out successfully for me. Pls. suggest me.ray.wurlod wrote:OK, we're not getting enough from the error message alone. Somewhere, perhaps in your source data, there is a value "R" that is not being successfully converted to a timestamp. Can you please theref ...
Thanks in advance...
veera...
veera...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: