When using the LastRowInGroup function, the data in the non-key fields get corrupted with control characters.
At first I thought it was an input data quality issue but I was even able to reproduce the problem with a RowGenerator stage.
The job I used to reproduce the problem is very simple:
RowGenerator (2 key fields, 1 non-key field) -> Transformer (with a sort on the 2 key fields; running in sequential mode like all other stages) -> a sequential file stage.
The function is called on the primary key field (first field).
I only get corruption after ~200,000 groups and no corruption is found when I remove the function.
Is anybody aware of this problem? I opened a PMR with IBM and will post the solution if found...
Thanks
LastRowInGroup corrupts non-key fields
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Have you installed Fix Pack 1? There are lots of things fixed in this. (You can read what they are at Information Center, you can download FP1 from Fix Central.)
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.