I tried to loader some data(numeric/decimal) into rebrick table using bulk loader and found some unusual scenario here.
what I did::
Input data Output(numeric 13, scale 2)
-850.00 -8.50(wrong)
50500.00 50500.00(right)
-470.22 -470.22(right)
from redbick table, the first numeric data give the wrong result. but not the 2nd/3rd. So was wondering whats gone wrong. Anyone have some ideas??
decimal/numeric data type error in redbrick bulk loader
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Preserve the data file, and be absolutely certain that -850.00 is generated by DataStage. This allows you to isolate the culprit. Make sure that the figure is in exactly the position specified in the control file.
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.