I am not able to load records into the UV table. The cause for rejections is stated as Mismatch in Data type in Log.
Intial design was directly loading the UV table from transformer.
Only certain records get rejected
But when tried using an intermedaite sequential file between the transformer and UV i was able to load the data without any rejections.
what could be the reason?
Thanks in advance
UV TABLE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's impossible to tell without knowing what the data types are and what data you are actually delivering.
You may be able to determine this by inspecting the warning messages in the log, or you can definitely see the data by tracing the Transformer stage.
The reason the intermediate text file works is that there are no real data types in text files, only text.
You may be able to determine this by inspecting the warning messages in the log, or you can definitely see the data by tracing the Transformer stage.
The reason the intermediate text file works is that there are no real data types in text files, only text.
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.