How to sort data in Server edition Jobs
I can see sort stage in Parallal edition for parallal and server jobs
but in server edition , how we are sorting?
How to sort data in Server edition Jobs
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sort stage, as Ken suggests, is available in server jobs. But it's slow.
If you have a DOS command line sorter available, it may be preferable to use that, perhaps as the Filter command in a Sequential File stage.
Other possibilities include a UV stage (or any other database stage) - load the data into a table then re-extract the data with an ORDER BY clause - this will be quite fast if you index the sorting column(s). You could also write your own sort routine if you're good at that sort of thing.
If you have a DOS command line sorter available, it may be preferable to use that, perhaps as the Filter command in a Sequential File stage.
Other possibilities include a UV stage (or any other database stage) - load the data into a table then re-extract the data with an ORDER BY clause - this will be quite fast if you index the sorting column(s). You could also write your own sort routine if you're good at that sort of thing.
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.