Hi,
I am trying to load null into decimal column from file into a table and it is throwing warning. I have used Isnull function and tried to load space instead of null but it is throwing warning message. Can any one assist me in loading null into decimal without warnings.
how to load null into decimal datatype without warning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You're not trying to load NULL, you're trying to load a space character, which (as noted) is not legal for Decimal data type. Therefore DataStage changes it to NULL and alerts you of that fact. To eliminate the warning, don't attempt to load " " into a Decimal field.
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.