ModifyStage::Possible range limitation.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's an alert, notifying you that a 255 character string may contain a number that is too large to load into a Decimal with precision less than 255.
You could try adding a NOWARN specification, but probably will end up adding a message handler to demote this particular alert to informational.
DataStage is trying to "do the right thing" by warning you.
Another (probably better) solution is to change the string to VarChar(38) (or whatever precision you've specified).
You could try adding a NOWARN specification, but probably will end up adding a message handler to demote this particular alert to informational.
DataStage is trying to "do the right thing" by warning you.
Another (probably better) solution is to change the string to VarChar(38) (or whatever precision you've specified).
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.
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: