DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
reshma11



Group memberships:
Premium Members

Joined: 13 Oct 2008
Posts: 25

Points: 187

Post Posted: Mon Feb 16, 2009 9:56 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Windows
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.
girija
Participant



Joined: 24 Mar 2006
Posts: 89
Location: Hartford
Points: 419

Post Posted: Mon Feb 16, 2009 10:36 am Reply with quote    Back to top    

Hi, Why are you using default decimal[38,10] in your input, sincne you know that the value should be within the range of NUMBER(5)? Probably you are using some oracle function when you select this from the source. Use CAST utility of oracle and get the value as NUMBER(5) instead of [38,10].
Rate this response:  
Not yet rated
mk_ds09
Participant



Joined: 25 Jan 2009
Posts: 72
Location: Pune
Points: 518

Post Posted: Mon Feb 16, 2009 11:01 am Reply with quote    Back to top    

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

_________________
-----------------------------------
Regards
MK

What would you attempt to do if you knew you could not fail?

-----------------------------------

Last edited by mk_ds09 on Tue Feb 17, 2009 3:05 am; edited 1 time in total
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 51928
Location: Sydney, Australia
Points: 281959

Post Posted: Mon Feb 16, 2009 2:39 pm Reply with quote    Back to top    

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?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours