Hi everyone,
I have the following very simple job:
Seq file -> Sort -> Seq file
The source file contains a list of decimal values that needs to be sorted.
When the type of the column is set to Decimal, the output results in "-Infinity" in each row, instead of the original values.
When I change it to another type, such as Integer or Float, the output is OK.
Since this is an upgrade from 7.5 to 8.1 and there are dozens of jobs in this project, I would like to solve this issue on the infrastructure level, rather than on the application level, so changing the type is not an option for me.
Could someone suggest a solution for this issus?
Is there a known problem with Sort and Decimal on 8.1?
thank you
Decimal Sort problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In version 8 server jobs have to run (on the principal node) in the parallel execution environment, so there is a deal of conversion of data types that needs to be achieved. I suspect what you're seeing is something to do with this, but you really need to involve your official support provider to verify the same.
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.