I am getting following warning message for a copy stage in the job when i am running.
Rej_Cp_T5_SalesChannels: When checking operator: When binding output schema variable "outRec": When binding output interface field "ORD_SEQ_NBR" to field "ORD_SEQ_NBR": Implicit conversion from source type "decimal[38,10]" to result type "int16": Possible range/precision limitation.
The warning is coming for this column, the copy stage input column ORD_SEQ_NBR Decimal length 38 scale 10 nullable Yes.
Output column ORD_SEQ_NBR Smallnt length 5 nullable Yes.
Please help on eliminating this warning, without suppressing it.
Thanks.
Implicit conversion from source type "decimal[38,10]&qu
Moderators: chulett, rschirm, roy
Decimal with floating scale is converted to the dfloat datatype.
That is why it is giving the error of truncation.
One of the solutions can be :-
1. Use modify stage to modify the datatypes.
2. Check what exactly the data type is required after the copy stage.
whether you are just processing it or inserting into the database?
Depeneds on that you can change the datatype before the point where it needs to be changed.
Hope this helps
That is why it is giving the error of truncation.
One of the solutions can be :-
1. Use modify stage to modify the datatypes.
2. Check what exactly the data type is required after the copy stage.
whether you are just processing it or inserting into the database?
Depeneds on that you can change the datatype before the point where it needs to be changed.
Hope this helps
Last edited by mk_ds09 on Tue Feb 17, 2009 3:05 am, edited 1 time in total.
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's not an error it's an alert.
The second person personal pronoun is spelled "you" in English, not "u", and the corresponding present tense of the verb "to be" is spelled "are", not "r". Please strive for a professional standard of written English on DSXchange; it helps those whose first language is not English. I do not have to point out that DSXchange is not a mobile telephone. Do you use these SMS-style abbreviations when documenting your work?
The second person personal pronoun is spelled "you" in English, not "u", and the corresponding present tense of the verb "to be" is spelled "are", not "r". Please strive for a professional standard of written English on DSXchange; it helps those whose first language is not English. I do not have to point out that DSXchange is not a mobile telephone. Do you use these SMS-style abbreviations when documenting your work?
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.