Hi
I am trying to read data from oracle and laod the data again to a table in oracle.
I am getting invalid number error. i checked the datatypes and loaded one by one. i found that one of my field "REP_ID" is causing invalid number error.
In the source it is of varchar datatype and nullable.
In the target it was decimal, but now I changed it to varchar and still it gives the same error.
REP_ID:
YAU102388
YSG-1
2390
I am unable to get what might be the problem
Invalid Number
Moderators: chulett, rschirm, roy
Invalid Number
Pradeep Kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Changing it in the DataStage job is not enough. If the target table still has it defined as a numeric data type, it still won't work with the alphabetic characters in it.
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.