input file data sort order and output file data order

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajendharreddy
Participant
Posts: 46
Joined: Tue Aug 21, 2007 5:39 am
Location: Bangalore, India

input file data sort order and output file data order

Post by rajendharreddy »

Hi,

We have observed below data order in the data when it is written to output file. This is a server job. Could anyone please explain.

We have input data order as mentioned below.

ID|NAME
1|A
2|B
3|C
4|D

Job is very simple and no contraints involved.

In output file, the data order should be same as it is in the input file. But, it is giving in below order. Basically, row order is changing. Could you please explain why?

ID|NAME
3|C
2|B
1|A
4|D

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If it's a server job why did you post it in the forum for parallel jobs?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Text file or hashed 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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

<moved>
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply